We've had a system in operation for a few years that makes use of a substantial
amount of partitioning. The parent table now has over 4,000 children tables.
Within the last couple of days the server started giving "out of shared memory"
errors with the suggestion to increase the max_locks_per_tr
Subject: Re: [ADMIN] max_locks_per_transaction and partitioned tables
Michael Holt writes:
> We've had a system in operation for a few years that makes use of a
> substantial amount of partitioning. The parent table now has over 4,000
> children tables. Within the last couple of d
Michael Holt writes:
> We've had a system in operation for a few years that makes use of a
> substantial amount of partitioning. The parent table now has over 4,000
> children tables. Within the last couple of days the server started giving
> "out of shared memory" errors with the suggestion to
We've had a system in operation for a few years that makes use of a substantial
amount of partitioning. The parent table now has over 4,000 children tables.
Within the last couple of days the server started giving "out of shared memory"
errors with the suggestion to increase the max_locks_per_tr
