Re: [HACKERS] Drop any statistics of table after it's truncated

2014-10-14 Thread Sawada Masahiko
On Tue, Oct 14, 2014 at 11:20 PM, Tom Lane wrote: > Sawada Masahiko writes: >> 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

Re: [HACKERS] Drop any statistics of table after it's truncated

2014-10-14 Thread Tom Lane
Sawada Masahiko writes: > 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 w

[HACKERS] Drop any statistics of table after it's truncated

2014-10-14 Thread Sawada Masahiko
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