Re: Concurrent read from a partition table.

On Tue, Jul 12, 2011 at 11:46 PM, hyelluas <helen_yelluas(at)mcafee(dot)com> 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 parameter like 'concurrent
> read' exist? I'm still new to postgres, came from oracle & mysql.
>
>
> Thanks.
> Helen
>
>
>
I tried with the attached test case and found that both the tables - base as
well as child tables are locked in shared mode for select queries.
For details, please check the attached inheritance_locks.txt file.

With "concurrent read" did you mean isolation settings?
Then please refer:
http://www.postgresql.org/docs/9.0/static/sql-set-transaction.html

Regards,
Chetan

--
EnterpriseDB Corporation
The Enterprise PostgreSQL Company

Website: www.enterprisedb.com
EnterpriseDB Blog : http://blogs.enterprisedb.com
Follow us on Twitter : http://www.twitter.com/enterprisedb