Hans-Juergen Schoenig <[EMAIL PROTECTED]> writes:
> i would suggest to replace the existing parameter but something else:
> - a switch to define the global size of the lock pool (e.g. "max_locks")
> - a switch which defines the upper limit for the current backend /
> transaction
The probl
Simon Riggs wrote:
On Thu, 2007-02-01 at 09:15 +0100, Hans-Juergen Schoenig wrote:
Right now max_locks_per_transactions defines the average number of locks
taken by a transaction. thus, shared memory is limited to
max_locks_per_transaction * (max_connections + max_prepared_transactions).
thi
On Thu, 2007-02-01 at 09:15 +0100, Hans-Juergen Schoenig wrote:
> Right now max_locks_per_transactions defines the average number of locks
> taken by a transaction. thus, shared memory is limited to
> max_locks_per_transaction * (max_connections + max_prepared_transactions).
> this is basically p