[PERFORM] Performance issues with postgresql-8.4.0: Query gets stuck sometimes

Hi, We are using postgresql-8.4.0 on 64-bit Linux machine (open-SUSE 11.x). It's a master/slave deployment & slony-2.0.4.rc2 is used for DB replication (from master to slave). At times we have observed that postgres stops responding for several minutes, even couldn't fetch the number of en

[PERFORM] Performance issues with postgresql-8.4.0

Hi, We are using postgresql-8.4.0 on 64-bit Linux machine (open-SUSE 11.x). It's a master/slave deployment & slony-2.0.4.rc2 is used for DB replication on the slave box. At times we have observed that postgres stops responding for several minutes, even couldn't fetch the number of entries i