Postgres Pro
Downloads
Home   >   mailing lists

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

From Shoaib Mir
Subject Re: how to increase performance of Postgre
Date
Msg-id bf54be870608010136r6fffc15t4d98e3817bbd3f2@mail.gmail.com
Whole thread Raw
In response to how to increase performance of Postgre  (Javanesevn <thanhle@sangtao.net>)
Responses Re: how to increase performance of Postgre  (Javanesevn <thanhle@sangtao.net>)
List pgsql-admin
Tree view
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: Thomas Günther
Date:
Subject: Cascading replication
Next
From: LiveShell
Date:
Subject: libpqxx + postgresql connection