[OT] Slony Triggers pulling down performance?

Поиск
Список
Период
Сортировка
От Ow Mun Heng
Тема [OT] Slony Triggers pulling down performance?
Дата
Msg-id 1200640481.5842.19.camel@neuromancer.home.net
обсуждение исходный текст
Ответы Re: [OT] Slony Triggers pulling down performance?  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-general
Just wondering if my 'Perceived' feeling that since implementing slony
for master/slave replication of select tables, my master database
performance is getting slower.

I'm constantly seeing a very high amount of IO wait. ~40-80 according to
vmstat 1

and according to atop. (hdb/hdc = raid1 mirror)
DSK |         hdb | busy     83% | read    1052 | write     50 | avio    7 ms |
DSK |         hdc | busy     81% | read    1248 | write     49 | avio    6 ms |


В списке pgsql-general по дате отправления:

Предыдущее
От: Stefan Schwarzer
Дата:
Сообщение: Re: Forgot to dump old data before re-installing machine
Следующее
От: Jean-Michel Pouré
Дата:
Сообщение: Re: advocacy: drupal and PostgreSQL