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@xxxxxxxxxxxxx www.ohl.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
