Re: BUG #5722: vacuum full does not update last_vacuum statistics

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Jochen Erwied <jochen(at)pgsql(dot)erwied(dot)eu>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5722: vacuum full does not update last_vacuum statistics
Date: 2010-10-25 15:20:11
Message-ID: 1288020011.4126.1.camel@hp-laptop02.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, 2010-10-25 at 16:48 +0200, Jochen Erwied wrote:
> Well, when reading
>
> http://www.postgresql.org/docs/current/static/monitoring-stats.html
>
> then last_vacuum contains the last time of a user-initiated vacuum.
> There's no distinction made what kind of vacuum was made. And IMHO
> even if VACUUM FULL isn't meant for routine vacuuming, the state
> should be changed.

+1, but I'm not sure whether this might be an appropriate change for 9.0
or not.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Brendan Jurd 2010-10-25 15:42:33 Re: Segfault in 9.0 inlining SRF
Previous Message Tom Lane 2010-10-25 15:03:07 Re: BUG #5722: vacuum full does not update last_vacuum statistics