You may need to increase mas_loks_per_trasaction

From: "Jonas Pacheco" <jonas(at)migrate(dot)com(dot)br>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: You may need to increase mas_loks_per_trasaction
Date: 2008-09-05 11:59:40
Message-ID: BC49B993FB36774A9ABD00096D42E6872523E7@mgtsrv02.migrate.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Claus Guttesen 2008-09-05 12:37:53 Re: You may need to increase mas_loks_per_trasaction
Previous Message Matthew Wakeling 2008-09-05 11:49:47 Re: too many clog files