Re: optimal sql

Поиск
Список
Период
Сортировка
От Michael Paesold
Тема Re: optimal sql
Дата
Msg-id 00a301c2c1fd$8fec4d30$3201a8c0@beeblebrox
обсуждение исходный текст
Ответ на Re: optimal sql  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Ответы Re: optimal sql
Список pgsql-sql
Achilleus Mantzios <achill@matrix.gatewaynet.com> wrote:

> For a) do all the necessary tuning on PostgreSQL.
> With 1GB of Mem, you could set a value of shared_buffers to 100000.

Perhaps just a type, but that is way to much! It would mean about 800 Mb
shared buffers! I would rather suggest a value between 1000 and 10000. See
recent descussions on -performance and -hackers mailing lists.

Best Regards,
Michael Paesold


В списке pgsql-sql по дате отправления: