tuning our database by increasing shared buffer

Поиск
Список
Период
Сортировка
От Barbara Stephenson
Тема tuning our database by increasing shared buffer
Дата
Msg-id 200906231502.30337.barbara@turbocorp.com
обсуждение исходный текст
Ответы Re: tuning our database by increasing shared buffer  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hello,
We will be consolidating from 4 databases to 2 and want to make sure that
these parameters are the only ones that need changing.   Please advise.

Current                                Future
=====                                =====
Max_connection = 50                    125
Shared_buffers = 16MB                    48MB

My concern is that max_locks_per_transaction and max_prepared_transaction are
still set as default??

Shouldn't we increase the max_locks_per_transaction from 64 to 100 or 128
since we have more than doubled the # of connections?

max_prepared_transaction is set at default of 5 which is says if we use it to
set it to max_connection.

Or leaving those 2 max parameters as default would be ok?
--
Regards,

Barbara Stephenson
EDI Specialist/Programmer
Turbo, division of OHL
2251 Jesse Jewell Pkwy
Gainesville, GA  30507
tel: (678)989-3020 fax: (404)935-6171
barbara@turbocorp.com
www.ohl.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] PK not being restored
Следующее
От: Tom Lane
Дата:
Сообщение: Re: tuning our database by increasing shared buffer