Concurrent read from a partition table.

Hello,

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?

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


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Concurrent-read-from-a-partition-table-tp4577154p4577154.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.