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 6259D9FB266 for ; Thu, 3 Aug 2006 08:04:22 -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 95027-02 for ; Thu, 3 Aug 2006 08:04:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ns.neo.co.jp (ns.neo.co.jp [219.101.217.194]) by postgresql.org (Postfix) with ESMTP id 0069A9FB220 for ; Thu, 3 Aug 2006 08:04:11 -0300 (ADT) Received: from localhost (ns.neo.co.jp [127.0.0.1]) by ns.neo.co.jp (Postfix) with ESMTP id BF8DE8C0DF for ; Thu, 3 Aug 2006 20:03:25 +0900 (JST) Received: from ns.neo.co.jp ([127.0.0.1]) by localhost (ns.neo.co.jp [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12971-03 for ; Thu, 3 Aug 2006 20:03:21 +0900 (JST) Received: from [172.18.3.69] (unknown [172.18.3.69]) by ns.neo.co.jp (Postfix) with ESMTP id 793CD8C0DE for ; Thu, 3 Aug 2006 20:03:21 +0900 (JST) Message-ID: <44D1D81B.50905@sangtao.net> Date: Thu, 03 Aug 2006 20:03:55 +0900 From: Javanesevn User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: how to increase performance of Postgre References: <44CEF854.70701@sangtao.net> In-Reply-To: Content-Type: multipart/alternative; boundary="------------010303090304030407050301" X-Virus-Scanned: amavisd-new at neo.co.jp X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.118 tagged_above=0 required=5 tests=AWL, HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200608/28 X-Sequence-Number: 22572 This is a multi-part message in MIME format. --------------010303090304030407050301 Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit Hi, Thanks for your check list. It's helpful with me. -Javanesevn Shoaib Mir wrote: > Have a look at http://www.powerpostgresql.com/PerfList/ and change > your settings accordingly. > > Thanks, > -- > Shoaib Mir > EnterpriseDB ( www.enterprisedb.com ) > > On 8/1/06, *Javanesevn* > wrote: > > Hi all, > > My project ( web application) is using Postgre 8.1 and PHP 4.x (ADO > library to access database). And I would like to increase > perfomance, so > I changed configuration follow this: > shared_buffers = 16000(Default = 1000) > wal_buffers = 64(Default = 8) > But this setting is not strong effect. Please show me other way or > your > idea to resolve my problem. Thanks a lot. > > Best regards, > > -Javanesevn. > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend > > > > > --------------010303090304030407050301 Content-Type: text/html; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit Hi,

Thanks for your check list. It's helpful with me.

-Javanesevn
Shoaib Mir wrote:
Have a look at http://www.powerpostgresql.com/PerfList/ and change your settings accordingly.

Thanks,
--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 8/1/06, Javanesevn <thanhle@sangtao.net> wrote:
Hi all,

My project ( web application) is using Postgre 8.1 and PHP 4.x (ADO
library to access database). And I would like to increase perfomance, so
I changed configuration follow this:
shared_buffers = 16000(Default = 1000)
wal_buffers = 64(Default = 8)
But this setting is not strong effect. Please show me other way or your
idea to resolve my problem. Thanks a lot.

Best regards,

-Javanesevn.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend





--------------010303090304030407050301--