Re: [GENERAL] [OT] Slony Triggers pulling down performance?

2008-01-27 Thread Ow Mun Heng
On Fri, 2008-01-18 at 14:57 -0500, Chris Browne wrote: [EMAIL PROTECTED] (Ow Mun Heng) writes: 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

Re: [GENERAL] [OT] Slony Triggers pulling down performance?

2008-01-18 Thread Andrew Sullivan
On Fri, Jan 18, 2008 at 03:14:41PM +0800, Ow Mun Heng wrote: Just wondering if my 'Perceived' feeling that since implementing slony for master/slave replication of select tables, my master database performance is getting slower. It imposes a performance penalty, yes. A

Re: [GENERAL] [OT] Slony Triggers pulling down performance?

2008-01-18 Thread Chris Browne
[EMAIL PROTECTED] (Ow Mun Heng) writes: 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

[GENERAL] [OT] Slony Triggers pulling down performance?

2008-01-17 Thread Ow Mun Heng
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