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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1
Дата
Msg-id 13952.1337812380@sss.pgh.pa.us
обсуждение исходный текст
Ответ на significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1  (Lonni J Friedman <netllama@gmail.com>)
Ответы Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1  (Lonni J Friedman <netllama@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Extreme PostgreSQL?
Следующее
От: Lonni J Friedman
Дата:
Сообщение: Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1