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

2010-07-05 Thread Robert Haas
On Fri, Jul 2, 2010 at 1:40 AM, Sachin Kumar wrote: > At times we have observed that postgres stops responding for several > minutes, even couldn’t fetch the number of entries in a particular table. > One such instance happens when we execute the following steps: Sounds sort of like a checkpoint

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

2010-07-01 Thread Scott Marlowe
On Fri, Jul 2, 2010 at 1:40 AM, Sachin Kumar wrote: > 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). You should really be running 8.4.4, not 8.4.0, as there are

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

2010-07-01 Thread Sachin Kumar
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