Re: Small TRUNCATE glitch - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Small TRUNCATE glitch
Date
Msg-id 4121.1207242464@sss.pgh.pa.us
Whole thread Raw
In response to Re: Small TRUNCATE glitch  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: psql \G command -- send query and output using extended format
Next
From: Svenne Krap
Date:
Subject: Re: [GENERAL] SHA1 on postgres 8.3