| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Dan Armbrust" <daniel(dot)armbrust(dot)list(at)gmail(dot)com> |
| Cc: | "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:05:24 |
| Message-ID: | dcc563d10901061305q419bb291uf7d4b84b642adf6b@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jan 6, 2009 at 1:39 PM, Dan Armbrust
<daniel(dot)armbrust(dot)list(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Armbrust | 2009-01-06 21:07:36 | Re: Slow Vacuum was: vacuum output question |
| Previous Message | Alvaro Herrera | 2009-01-06 21:01:43 | Re: Slow Vacuum was: vacuum output question |