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@xxxxxxxxxxx>
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
|