Re: [HACKERS] max_locks_per_transactions ...

2007-02-01 Thread Tom Lane
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

Re: [HACKERS] max_locks_per_transactions ...

2007-02-01 Thread Hans-Juergen Schoenig
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

Re: [HACKERS] max_locks_per_transactions ...

2007-02-01 Thread Simon Riggs
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