| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
| Cc: | Lonni J Friedman <netllama(at)gmail(dot)com>, Andy Colson <andy(at)squeakycode(dot)net>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1 |
| Date: | 2012-05-23 22:33:00 |
| Message-ID: | 13952.1337812380@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lonni J Friedman | 2012-05-23 22:33:36 | Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1 |
| Previous Message | Devrim GÜNDÜZ | 2012-05-23 21:49:15 | Re: Extreme PostgreSQL? |