Postgres Pro
Downloads
Home   >   mailing lists

Re: You may need to increase mas_loks_per_trasaction - Mailing list pgsql-performance

From Greg Smith
Subject Re: You may need to increase mas_loks_per_trasaction
Date
Msg-id Pine.GSO.4.64.0809051642020.10853@westnet.com
Whole thread Raw
In response to You may need to increase mas_loks_per_trasaction  ("Jonas Pacheco" <jonas@migrate.com.br>)
List pgsql-performance
Tree view 
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 set) at
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: too many clog files
Next
From: Bruce Momjian
Date:
Subject: Re: SAN and full_page_writes