Postgres Pro
Downloads
Home   >   mailing lists

[OT] Slony Triggers pulling down performance? - Mailing list pgsql-general

From Ow Mun Heng
Subject [OT] Slony Triggers pulling down performance?
Date
Msg-id 1200640481.5842.19.camel@neuromancer.home.net
Whole thread Raw
Responses Re: [OT] Slony Triggers pulling down performance?  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Stefan Schwarzer
Date:
Subject: Re: Forgot to dump old data before re-installing machine
Next
From: Jean-Michel Pouré
Date:
Subject: Re: advocacy: drupal and PostgreSQL