[OT] Slony Triggers pulling down performance?

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [OT] Slony Triggers pulling down performance?
Date: 2008-01-18 07:14:41
Message-ID: 1200640481.5842.19.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 |

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Michel Pouré 2008-01-18 07:55:09 Re: advocacy: drupal and PostgreSQL
Previous Message Niederland 2008-01-18 06:40:02 Re: postgresql 8.3rc1 on vista