Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1 - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1
Date
Msg-id 13952.1337812380@sss.pgh.pa.us
Whole thread Raw
In response to significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1  (Lonni J Friedman <netllama@gmail.com>)
Responses Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1
List pgsql-general
Gavin Flower <GavinFlower@archidevsys.co.nz> writes:
>> 16 core Xeon X5550 2.67GHz
>> 128GB RAM
>> $PGDATA sits on a RAID5 array comprised of 3 SATA disks.  Its Linux's
>> md software RAID.

> How does this compare to your other machines running the same, or
> similar, databases?
> However, you do say that the other machines are indentical - but are the
> other
> machines different in any aspect, that might prove siginificant?

I think Lonnie said that the other machines are just running standby
clusters, which would mean they aren't running autovacuum as such,
merely applying any WAL it produces.  So that could be plenty enough
to explain a difference in kernel-visible behavior.

            regards, tom lane

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Extreme PostgreSQL?
Next
From: Lonni J Friedman
Date:
Subject: Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1