I’m having a problem with concurrent processing. 2 queries are accessing the same parent table that have 24 partitions. I see “shared lock is not granted “ for one of them on one of the children while the other query is running.
Does the “ select from a parent table” make a lock on the children?
In general if there are no predicates in query, then select would be fired across all children.
How I can change it? The one of the queries runs hourly ( 8 min) on the server , the other one can be run by a user , and a few users can run the same query.
Thank you. Helen
Could you post a self-contained test case?
Regards, Chetan
--
EnterpriseDB Corporation The Enterprise PostgreSQL Company