Re: You may need to increase mas_loks_per_trasaction

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Jonas Pacheco <jonas(at)migrate(dot)com(dot)br>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: You may need to increase mas_loks_per_trasaction
Date: 2008-09-05 20:43:59
Message-ID: Pine.GSO.4.64.0809051642020.10853@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2008-09-06 19:46:40 Re: SAN and full_page_writes
Previous Message Scott Marlowe 2008-09-05 16:39:09 Re: too many clog files