Postgres Pro
Downloads
Home   >   mailing lists

Locking in Inheritance partition - Mailing list pgsql-admin

From Gaurav Anand
Subject Locking in Inheritance partition
Date
Msg-id CAMZ99nd5AxvTi9ydjv-FJWmaWbo-npoqLciOmyOPhm7BERjEPQ@mail.gmail.com
Whole thread Raw
Responses Re: Locking in Inheritance partition  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-admin
Tree view
Hi Team,

We have a declarative partition on tables in our database which is PG10. We face issues as the table becomes locked during attach and detach and cannot be used during the event.

We have a master and slave setup and application query points to Slave but whenever we perform attach and detach of partitions on Master the locks propagates to slave and causes Application to spin.

Kindly suggest if  Inheritance partition will help here or any other way I can avoid this lock.

Thanks,
Gaurav
--

Thanks.

Regards,
Gaurav Anand

logo

This communication is confidential and subject to and governed by Saama’s Electronic Communications Disclaimer.

 

pgsql-admin by date:

Previous
From: abbas alizadeh
Date:
Subject: Last login time
Next
From: Thomas Kellerer
Date:
Subject: Re: Locking in Inheritance partition