| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Dan Armbrust" <daniel(dot)armbrust(dot)list(at)gmail(dot)com> |
| Cc: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, "Andrew Sullivan" <ajs(at)crankycanuck(dot)ca>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Slow Vacuum was: vacuum output question |
| Date: | 2009-01-06 21:36:14 |
| Message-ID: | 11645.1231277774@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Dan Armbrust" <daniel(dot)armbrust(dot)list(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Armbrust | 2009-01-06 21:44:59 | Re: Slow Vacuum was: vacuum output question |
| Previous Message | Scott Marlowe | 2009-01-06 21:33:30 | Re: Slow Vacuum was: vacuum output question |