Re: Why is plan (and performance) different on partitioned table?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why is plan (and performance) different on partitioned table?
Дата
Msg-id 26842.1146601672@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why is plan (and performance) different on partitioned table?  ("Mark Liberman" <mliberman@mixedsignals.com>)
Список pgsql-performance
Дерево обсуждения 
"Mark Liberman" <mliberman@mixedsignals.com> writes:
> Now, the potentital bug:
> It appears that after you truncate a table, the statistics for that =
> table still remain in pg_statistics.

That's intentional, on the theory that when the table is re-populated
the new contents will probably resemble the old.

            regards, tom lane

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: postgresql transaction id monitoring with nagios
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Performance Issues on Opteron Dual Core