Re: Slow join on partitioned table

Поиск
Список
Период
Сортировка
От Mark Thornton
Тема Re: Slow join on partitioned table
Дата
Msg-id 4D711AAB.5010801@optrak.co.uk
обсуждение исходный текст
Ответ на Re: Slow join on partitioned table  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Slow join on partitioned table
Список pgsql-performance
On 04/03/2011 16:07, Robert Haas wrote:
> That seems quite surprising. There are only 14 rows in the table but
> PG thinks 2140?  Do you have autovacuum turned on?  Has this table
> been analyzed recently?
>
I think autovacuum is enabled, but as a temporary table LinkIds has only
existed for a very short time (at least in my current tests).

Mark



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

Предыдущее
От: Mark Thornton
Дата:
Сообщение: Re: Slow join on partitioned table
Следующее
От: Glyn Astill
Дата:
Сообщение: Linux I/O schedulers - CFQ & random seeks