Mark Lewis <[EMAIL PROTECTED]> writes:
> You really, really want to upgrade as soon as possible,
No, sooner than that. Show your boss the list of known
data-loss-causing bugs in 7.2.1, and refuse to take responsibility
if the database eats all your data before the "in good time" upgrade.
The rel
On Mon, Jan 30, 2006 at 03:26:23PM -0800, Mark Lewis wrote:
> You have lots of dead rows. Do a vacuum full to get it under control,
> then run VACUUM more frequently and/or increase your FSM settings to
> keep dead rows in check. In 7.2 vacuum is pretty intrusive; it will be
> much better behaved
with Postgresql 7.2.1 you will need to do BOTH vacuum and reindex and with a
table that gets many updates/deletes, you
should run vacuum more than daily.
Both issues have been solved in 8.1.
Jim
-- Original Message ---
From: Emmanuel Lacour <[EMAIL PROTECTED]>
To: pgsql-perfo
You have lots of dead rows. Do a vacuum full to get it under control,
then run VACUUM more frequently and/or increase your FSM settings to
keep dead rows in check. In 7.2 vacuum is pretty intrusive; it will be
much better behaved once you can upgrade to a more recent version.
You really, really
