You may need to increase mas_loks_per_trasaction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: <pgsql-performance@xxxxxxxxxxxxxx>
Subject: You may need to increase mas_loks_per_trasaction
From: "Jonas Pacheco" <jonas@xxxxxxxxxxxxxx>
Date: Fri, 5 Sep 2008 08:59:40 -0300
References: <alpine.DEB.1.10.0809051247450.4454@xxxxxxxxxxxxxxxxxxx>
Thread-index: AckPTXmNa714WWoRRiqxx0msvc803gAAFjVg
Thread-topic: You may need to increase mas_loks_per_trasaction

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

Follow-Ups:
- Re: You may need to increase mas_loks_per_trasaction
  - From: Greg Smith
- Re: You may need to increase mas_loks_per_trasaction
  - From: Claus Guttesen

References:
- Re: too many clog files
  - From: Matthew Wakeling

Prev by Date: Re: too many clog files
Next by Date: Re: You may need to increase mas_loks_per_trasaction
Previous by thread: Re: too many clog files
Next by thread: Re: You may need to increase mas_loks_per_trasaction
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux