Skip site navigation (1) Skip section navigation (2)

Re: BUG #5932: CLUSTER doesn't update n_dead_tup

From: Andy Lester <andy(at)petdance(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5932: CLUSTER doesn't update n_dead_tup
Date: 2011-09-06 14:07:46
Message-ID: 8416A5E4-4A10-4142-AE4F-EC1FE66566AC@petdance.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Sep 6, 2011, at 9:04 AM, Bruce Momjian wrote:

> Well, if you TRUNCATE I don't think it updates the statistics either.  I
> think we assume the autovacuum system will analyse the new table soon.


When I brought this up in IRC, I recall that that sentiment was expressed, along with the standard "What do you mean you're not running autovacuum?"  

--
Andy Lester => andy(at)petdance(dot)com => www.petdance.com => AIM:petdance

In response to

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2011-09-06 14:08:59
Subject: Re: BUG #5932: CLUSTER doesn't update n_dead_tup
Previous:From: Bruce MomjianDate: 2011-09-06 14:04:42
Subject: Re: BUG #5932: CLUSTER doesn't update n_dead_tup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group