Postgres Pro
Downloads
Home   >   mailing lists

Re: Thoughts on maintaining 7.3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Thoughts on maintaining 7.3
Date
Msg-id 28339.1065334271@sss.pgh.pa.us
Whole thread Raw
In response to Re: Thoughts on maintaining 7.3  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Thoughts on maintaining 7.3  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized table layout)
Next
From: Bruno Wolff III
Date:
Subject: Re: pg_dump bug in 7.4