Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 81FC263332D for ; Fri, 2 Jul 2010 02:40:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 10179-05 for ; Fri, 2 Jul 2010 05:40:17 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from emailsecurity-del1-1.globallogic.com (mx-del1-1.globallogic.com [202.174.92.25]) by mail.postgresql.org (Postfix) with ESMTP id 01B76632374 for ; Fri, 2 Jul 2010 02:40:16 -0300 (ADT) Received: from emailsecurity-del1-1.globallogic.com (127.0.0.1) by emailsecurity-del1-1.globallogic.com (MlfMTA v3.2r9) id h5lsvo0171s1 for ; Fri, 2 Jul 2010 11:02:40 +0530 (envelope-from ) Received: from ex2-del1.synapse.com ([172.16.2.50]) by emailsecurity-del1-1.globallogic.com (SonicWALL 7.2.1.2841) with ESMTP; Fri, 02 Jul 2010 11:02:40 +0530 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CB19A9.0AC1DDBD" Subject: Performance issues with postgresql-8.4.0: Query gets stuck sometimes Date: Fri, 2 Jul 2010 11:10:13 +0530 Message-ID: <21026437C2BC0D45BE196CB0A35EFEFD052D620B@ex2-del1.synapse.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Performance issues with postgresql-8.4.0: Query gets stuck sometimes Thread-Index: AcsXWi1dkLtyyRqGSWivrYPnXY/+YwCT3h2w From: "Sachin Kumar" To: Cc: "Vivek Gupta" X-Mlf-Version: 7.2.1.2841 X-Mlf-UniqueId: o201007020532400014009 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.01 tagged_above=-10 required=5 tests=BAYES_20=-0.001, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201007/20 X-Sequence-Number: 39409 This is a multi-part message in MIME format. ------_=_NextPart_001_01CB19A9.0AC1DDBD Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, =20 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).=20 =20 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: - Add few lakh entries (~20) to table X on the master DB. - After addition, slony starts replication on the slave DB. It takes several minutes (~25 mins) for replication to finish. - During this time (while replication is in progress), sometimes postgres stops responding, i.e. we couldn't even fetch the number of entries in any table (X, Y, etc). =20 Can you please let us know what could the reason for such a behavior and how it can be fixed/improved. =20 Please let us know if any information is required wrt hardware details/configurations etc. =20 Regards, Sachin =20 ------_=_NextPart_001_01CB19A9.0AC1DDBD Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 entries in a particular table. = One such instance happens when we execute the following = steps:

-         Add few lakh entries (~20) to table X on the master = DB.

-         After addition, slony starts replication on the slave DB. It takes several = minutes (~25 mins) for replication to finish.

-         During this time (while replication is in progress), sometimes postgres stops responding, i.e. we couldn’t even fetch the number of entries in any table (X, Y, = etc).

 

Can you please let us know what = could the reason for such a behavior and how it can be = fixed/improved.

 

Please let us know if any = information is required wrt hardware details/configurations = etc.

 

Regards,

Sachin

 

------_=_NextPart_001_01CB19A9.0AC1DDBD--