Re: how to increase performance of Postgre

Поиск
Список
Период
Сортировка
От adey
Тема Re: how to increase performance of Postgre
Дата
Msg-id 1c66bda80608021754i1aa91c43j28e333384640e84@mail.gmail.com
обсуждение исходный текст
Ответ на how to increase performance of Postgre  (Javanesevn <thanhle@sangtao.net>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: adey
Дата:
Сообщение: Re: What's using all my RAM?
Следующее
От: Javanesevn
Дата:
Сообщение: Re: how to increase performance of Postgre