Обсуждение: how to increase performance of Postgre
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.
Have a look at http://www.powerpostgresql.com/PerfList/ and change your settings accordingly.
Thanks,
--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
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
On Tue, 2006-08-01 at 01:44, 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. 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 explain analyze YOUR QUERY GOES HERE Not explain, explain analyze. Generally, the more information you give the better.
How much RAM do you have, and what is your SHMMAX set to?
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
Hi,
Thanks for your check list. It's helpful with me.
-Javanesevn
Shoaib Mir wrote:
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