pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPG10 Attach-Detach Partition in Declarative vs Inheritance
2+ messages / 1 participants
[nested] [flat]
* PG10 Attach-Detach Partition in Declarative vs Inheritance
@ 2022-02-14 05:54 Gaurav Anand <gaurav.anand@saama.com>
2022-02-15 07:16 ` PG10 Attach-Detach Partition in Declarative vs Inheritance Gaurav Anand <gaurav.anand@saama.com>
0 siblings, 1 reply; 2+ messages in thread
From: Gaurav Anand @ 2022-02-14 05:54 UTC (permalink / raw)
To: pgsql-admin@postgresql.org, pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi Team,
I need your kind suggestion:
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 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
[image: logo] <https://bit.ly/3nJh91F;
--
This communication is confidential and
subject to and governed by Saama’s
Electronic
Communications Disclaimer.
<https://www.saama.com/email-communication-disclaimer/;
^ permalink raw reply [nested|flat] 2+ messages in thread
* PG10 Attach-Detach Partition in Declarative vs Inheritance
2022-02-14 05:54 PG10 Attach-Detach Partition in Declarative vs Inheritance Gaurav Anand <gaurav.anand@saama.com>
@ 2022-02-15 07:16 ` Gaurav Anand <gaurav.anand@saama.com>
0 siblings, 0 replies; 2+ messages in thread
From: Gaurav Anand @ 2022-02-15 07:16 UTC (permalink / raw)
To: pgsql-admin <pgsql-admin@lists.postgresql.org>; pgsql-admin
> Hi Team,
>
> I need your kind suggestion:
> 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 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
>
> [image: logo] <https://bit.ly/3nJh91F;
>
--
Thanks.
Regards,
Gaurav Anand
[image: logo] <https://bit.ly/2Y3a6rA;
--
This communication is confidential and
subject to and governed by Saama’s
Electronic
Communications Disclaimer.
<https://www.saama.com/email-communication-disclaimer/;
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-02-15 07:16 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-02-14 05:54 PG10 Attach-Detach Partition in Declarative vs Inheritance Gaurav Anand <gaurav.anand@saama.com>
2022-02-15 07:16 ` Gaurav Anand <gaurav.anand@saama.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox