Drop any statistics of table after it's truncated

Поиск
Список
Период
Сортировка
От Sawada Masahiko
Тема Drop any statistics of table after it's truncated
Дата
Msg-id CAD21AoBhE7pX2cxUNNAHZv3RO5LmoW6UqeW3pbQLwOr+-RCM1A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Drop any statistics of table after it's truncated  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi all,

I found that the statistics are still remained after it's truncated.
In addition, the analyzing ignores table does not have any tuple.
After table truncated, the entry of statistics continues to remain
unless insertion and analyzing are executed.
There is reason why statistics are remained?

Attached patch is one line patch adds RemoveStatistics() into
ExecuteTruncate(), to remove statistics entry of table.

--
Regards,

-------
Sawada Masahiko

Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: WIP: dynahash replacement for buffer table
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Wait free LW_SHARED acquisition - v0.9