Re: You may need to increase mas_loks_per_trasaction

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: You may need to increase mas_loks_per_trasaction
Дата
Msg-id Pine.GSO.4.64.0809051642020.10853@westnet.com
обсуждение исходный текст
Ответ на You may need to increase mas_loks_per_trasaction  ("Jonas Pacheco" <jonas@migrate.com.br>)
Список 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@gregsmith.com http://www.gregsmith.com Baltimore, MD

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: too many clog files
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: SAN and full_page_writes