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

From Scott Marlowe
Subject Re: Slow Vacuum was: vacuum output question
Date
Msg-id dcc563d10901061305q419bb291uf7d4b84b642adf6b@mail.gmail.com
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
List pgsql-general
On Tue, Jan 6, 2009 at 1:39 PM, Dan Armbrust
<daniel.armbrust.list@gmail.com> wrote:
> Here is an interesting new datapoint.
>
> Modern Ubuntu distro - PostgreSQL 8.1.  SATA drive.  No Raid.  Cannot
> reproduce slow vacuum performance - vacuums take less than a second
> for the whole database.
>
> Reinstall OS - Fedora Core 6 - PostgreSQL 8.1.  Push data through
> PostgreSQL for a couple hours (same as above) and now vacuum reports
> this:

Are you pushing the same amount of data through the ubuntu server?  if
not, then the comparison is invalid, if so, then yeah, there's some
kind of difference between the platforms.

Note that Fedora Core 6 is quite old compared to ubuntu 8.04 or 8.10.
Also it's more likely to be installed on older and / or slower
equipment.

pgsql-general by date:

Previous
From: "Rob Richardson"
Date:
Subject: Generic provider for .Net
Next
From: "Dan Armbrust"
Date:
Subject: Re: Slow Vacuum was: vacuum output question