On Fri, 5 Sep 2008, Jonas Pacheco wrote:
max_prepared_transactions?
This is covered pretty well by the documentation:
http://www.postgresql.org/docs/current/static/runtime-config-resource.html
There are suggestions for everything else you asked about (and a few more
things you should also
> Considering a quad core server processor, 4 GBs of RAM memory, disk Sata
> 2.
>
> What is the recommended setting for the parameters:
>
> max_connections:70
Depends on how many clients that access the database.
> shared_buffers?
I have mine at 512 MB but I will lower it and see how it affects
Considering a quad core server processor, 4 GBs of RAM memory, disk Sata
2.
What is the recommended setting for the parameters:
max_connections:70
max_prepared_transactions?
shared_buffers?
wal_buffers?
max_fsm_relations?
max_fsm_pages?
Atenciosamente,
Jonas Rodrigo
--
Sent via pgsql-perfo
