Re: Slow Vacuum was: vacuum output question - Mailing list pgsql-general

From Tom Lane
Subject Re: Slow Vacuum was: vacuum output question
Date
Msg-id 11645.1231277774@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow Vacuum was: vacuum output question  ("Dan Armbrust" <daniel.armbrust.list@gmail.com>)
Responses Re: Slow Vacuum was: vacuum output question  ("Dan Armbrust" <daniel.armbrust.list@gmail.com>)
List pgsql-general
"Dan Armbrust" <daniel.armbrust.list@gmail.com> writes:
> INFO:  "cpe": found 415925 removable, 50003 nonremovable row versions
> in 10849 pages

> What on earth could be going on between PostgreSQL 8.1 and Fedora 6
> that is bloating and/or corrupting the indexes like this?

You're focusing on the indexes when the problem is dead table rows.

It's very hard to believe that there's any OS dependence as such
involved in that.  I wonder whether (a) the Ubuntu and Fedora packages
you're using are the same 8.1.x point release; (b) if there's any
interesting non-default behavior built into the Ubuntu packaging
... like running autovacuum automatically, for instance.

            regards, tom lane

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Slow Vacuum was: vacuum output question
Next
From: "Dan Armbrust"
Date:
Subject: Re: Slow Vacuum was: vacuum output question