View Single Post

   
  #3 (permalink)  
Old 04-15-2008, 11:50 PM
Tom Lane
 
Posts: n/a
Default Re: Small TRUNCATE glitch

Martijn van Oosterhout <kleptog@svana.org> writes:
> On Thu, Apr 03, 2008 at 11:58:11AM -0400, Tom Lane wrote:
>> Just noticed that TRUNCATE fails to clear the stats collector's counts
>> for the table. I am not sure if it should reset the event counts or
>> not (any thoughts?) but surely it is wrong to not zero the live/dead
>> tuple counts.


> Wern't there complaints from people regularly truncating and
> refilling tables getting bad plans because they lost the statistics?


Not related --- the planner doesn't look at pgstats data.

regards, tom lane

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply With Quote