Re: Small TRUNCATE glitch

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Small TRUNCATE glitch
Date: 2008-04-03 17:02:34
Message-ID: 20080403170234.GC22851@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-04-03 17:06:25 Re: modules
Previous Message D'Arcy J.M. Cain 2008-04-03 16:57:57 Re: modules