Re: indexing for left join

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: indexing for left join
Дата
Msg-id 43CFB5CD.9070704@archonet.com
обсуждение исходный текст
Ответ на indexing for left join  (T E Schmitz <mailreg@numerixtechnology.de>)
Список pgsql-sql
T E Schmitz wrote:
> 
> Sequential despite the indices? Or is this because the tables of my test 
> DB are virtually empty?

Yes - read up on analyse and column statistics for details. Oh, you've 
probably missed about vacuuming too.

--   Richard Huxton  Archonet Ltd


В списке pgsql-sql по дате отправления: