Postgres Pro
Downloads
Home   >   mailing lists

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

From adey
Subject Re: how to increase performance of Postgre
Date
Msg-id 1c66bda80608021754i1aa91c43j28e333384640e84@mail.gmail.com
Whole thread Raw
In response to how to increase performance of Postgre  (Javanesevn <thanhle@sangtao.net>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: adey
Date:
Subject: Re: What's using all my RAM?
Next
From: Javanesevn
Date:
Subject: Re: how to increase performance of Postgre