max_locks_per_transaction and partitioned tables

Поиск
Список
Период
Сортировка
От Michael Holt
Тема max_locks_per_transaction and partitioned tables
Дата
Msg-id E7907DC29186A94988A077445AFD1DC014975161@EXCHANGEVIC.ad.terapeak.com
обсуждение исходный текст
Список pgsql-admin

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_transaction.

 

If the parent table is queried will it require a lock for each one of the child tables? I’m guessing it will.

-- 
Michael Holt   |   Manager, Data Services   |   Linkedin Profile

michael@terapeak.com

102-3962 Borden Street, Victoria, B.C., Canada V8P 3H8

 

 

 

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

Предыдущее
От: Walter Hurry
Дата:
Сообщение: Re: Windows Services and Postgresql 9.1.3
Следующее
От: John Coryat
Дата:
Сообщение: Multiple servers with Postgresql