Horton

Re: Thoughts on maintaining 7.3

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Alvaro Herrera <alvherre@dcc.uchile.cl>, "Joshua D. Drake" <jd@commandprompt.com>, pgsql-hackers@postgresql.org
Date: 2003-10-05T06:11:11Z
Lists: pgsql-hackers 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> By doing REINDEX always, we eliminate some folks are are happy
> doing VACUUM FULL at night, because very few tuples are expired.

But if they have very few tuples expired, why do they need VACUUM FULL?
Seems to me that VACUUM FULL should be designed to cater to the case
of significant updates.

			regards, tom lane