X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8A83B9FB1FD for ; Tue, 1 Aug 2006 12:25:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 45086-10 for ; Tue, 1 Aug 2006 12:25:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 5C2169FA68D for ; Tue, 1 Aug 2006 12:25:01 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Tue, 1 Aug 2006 15:24:59 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 01 Aug 2006 10:24:59 -0500 Subject: Re: how to increase performance of Postgre From: Scott Marlowe To: Javanesevn Cc: pgsql-admin@postgresql.org In-Reply-To: <44CEF854.70701@sangtao.net> References: <44CEF854.70701@sangtao.net> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1154445899.7882.1.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 01 Aug 2006 10:24:59 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.083 tagged_above=0 required=5 tests=AWL, SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200608/8 X-Sequence-Number: 22552 On Tue, 2006-08-01 at 01:44, Javanesevn wrote: > Hi all, >=20 > My project ( web application) is using Postgre 8.1 and PHP 4.x (ADO=20 > library to access database). And I would like to increase perfomance, so=20 > I changed configuration follow this: > shared_buffers =3D 16000=EF=BC=88Default =3D 1000=EF=BC=89 > wal_buffers =3D 64=EF=BC=88Default =3D 8=EF=BC=89 > But this setting is not strong effect. Please show me other way or your=20 > idea to resolve my problem. Thanks a lot. You need to subscribe to the pgsql-performance list, and once there, post the queries that are running slow, and the output of running them with=20 explain analyze YOUR QUERY GOES HERE Not explain, explain analyze. Generally, the more information you give the better.