X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D12C1D1C514 for ; Mon, 11 Aug 2003 11:34:42 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 83516-05 for ; Mon, 11 Aug 2003 08:33:15 -0300 (ADT) Received: from popularworld.com (unknown [203.194.162.107]) by svr1.postgresql.org (Postfix) with ESMTP id F1DA8D1C4D9 for ; Mon, 11 Aug 2003 08:34:30 -0300 (ADT) Received: from joey ([202.64.84.81]) by popularworld.com ; Mon, 11 Aug 2003 19:34:32 +0800 Message-ID: <001a01c35ffc$651e7cc0$71327f81@joey> From: To: Subject: Peformance of Update Date: Mon, 11 Aug 2003 19:33:32 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0017_01C3603F.73063A60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.8 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE, NO_REAL_NAME X-Spam-Level: * X-Archive-Number: 200308/162 X-Sequence-Number: 2979 This is a multi-part message in MIME format. ------=_NextPart_000_0017_01C3603F.73063A60 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: quoted-printable Hi, Currently we are using postgresql 7.3 with Redhat linux 9. We find that= when we try to execute 200,000 update statement through JDBC, the performa= nce of degraded obviously for each update statement when comparing with les= s update statement(eg. 5000). Is there any suggestion that we can improve t= he performance for executing update statement at postgresql ? Thanks. Regards, Ricky. ------=_NextPart_000_0017_01C3603F.73063A60 Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable
Hi,
    Currently we are using postgresql 7.= 3 with=20 Redhat linux 9. We find that when we try to execute 200,000 update statemen= t=20 through JDBC, the performance of degraded obviously for each update stateme= nt=20 when comparing with less update statement(eg. 5000). Is there any suggestio= n=20 that we can improve the performance for executing update statement at= =20 postgresql ? Thanks.
 
Regards,
Ricky.
------=_NextPart_000_0017_01C3603F.73063A60--