Re: how to increase performance of Postgre - Mailing list pgsql-admin

From Javanesevn
Subject Re: how to increase performance of Postgre
Date
Msg-id 44D1D81B.50905@sangtao.net
Whole thread Raw
In response to Re: how to increase performance of Postgre  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-admin
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





pgsql-admin by date:

Previous
From: adey
Date:
Subject: Re: how to increase performance of Postgre
Next
From: "Mr. Dan"
Date:
Subject: Re: On-line backup - /bin/tar: Error exit delayed from previous errors