On Tue, Jul 12, 2011 at 11:46 PM, hyelluas wrote:
> Hi Chetan,
>
> I'm not sure how I can create a test case, I'm running queryes on 50g of
> data to see this.
>
> My general questions are about locking children when select from a parent,
> I
> have not seen any documentation on it. Does any para
Hi Chetan,
I'm not sure how I can create a test case, I'm running queryes on 50g of
data to see this.
My general questions are about locking children when select from a parent, I
have not seen any documentation on it. Does any parameter like 'concurrent
read' exist? I'm still new to postgres, c
On Tue, Jul 12, 2011 at 6:01 AM, hyelluas wrote:
> 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.
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
