| From: | Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Drop any statistics of table after it's truncated |
| Date: | 2014-10-14 13:32:10 |
| Message-ID: | CAD21AoBhE7pX2cxUNNAHZv3RO5LmoW6UqeW3pbQLwOr+-RCM1A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| Attachment | Content-Type | Size |
|---|---|---|
| Drop_statistics_after_truncated_v1.patch | application/octet-stream | 488 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2014-10-14 13:40:49 | Re: Wait free LW_SHARED acquisition - v0.9 |
| Previous Message | Robert Haas | 2014-10-14 13:30:58 | WIP: dynahash replacement for buffer table |