Search Postgresql Archives

Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Gavin Flower <GavinFlower@xxxxxxxxxxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux