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
Drop_statistics_after_truncated_v1.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
