Postgres Pro
Downloads
Home   >   mailing lists

Postgres 10 - Attach-Detach Partition in Declarative vs Inheritance - Mailing list pgsql-admin

From Gaurav Anand
Subject Postgres 10 - Attach-Detach Partition in Declarative vs Inheritance
Date
Msg-id CAMZ99nfFRPxwoQfH676z1+Xtpm_Q778Yew+DkCOkYyjDsW_zyg@mail.gmail.com
Whole thread Raw
Responses Re: Postgres 10 - Attach-Detach Partition in Declarative vs Inheritance  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view
Hi Team,

I need your kind recommendation
We have Postgres 10 and have partition tables currently with Declarative partitions. When we refresh the data and detach and attach the partition, during this time our Application which has Sql query on these tables takes Lock and sometimes a deadlock situation also arises.
 
To overcome the deadlock we used, advisory lock however the application still keeps waiting for lock to release.

Please suggest the best way - 
1. Will Inheritance partition (in PG10) help avoid the explicit locks.
2. Is upgrading the only choice? if so which version of PG.
3. Please suggest any other work around.

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: Kenny Bachman
Date:
Subject: Re: postgresql memory problem
Next
From: Thomas Kaliakos
Date:
Subject: Programmatic access to the SQL tab of pgadmin