public inbox for [email protected]help / color / mirror / Atom feed
Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() 3+ messages / 3 participants [nested] [flat]
* Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() @ 2024-07-19 14:25 Christoph Berg <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Christoph Berg @ 2024-07-19 14:25 UTC (permalink / raw) To: Durgamahesh Manne <[email protected]>; +Cc: [email protected]; [email protected] Re: Durgamahesh Manne > with pg_partman By default proc() does not detach tables concurrently. How > do we implement tables detach concurrently without blocking other sessions > Here queries not using date column to detach tables with > run_maintenance_proc() which is not using concurrently based on the > retention policy which leads to scan all available child tables hence need > to trigger this proc with concurrently option to avoid blocking other child > tables beyond rentention policy while running statements on them You might have more success by filing pg_partman issues at https://github.com/pgpartman/pg_partman/issues > Do we have any other alternative rather than using pg_partman()? Well you can just run the same commands manually that pg_partman would run. Christoph ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() @ 2024-07-19 14:56 Durgamahesh Manne <[email protected]> parent: Christoph Berg <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Durgamahesh Manne @ 2024-07-19 14:56 UTC (permalink / raw) To: Christoph Berg <[email protected]>; Durgamahesh Manne <[email protected]>; [email protected]; [email protected] On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg <[email protected]> wrote: > Re: Durgamahesh Manne > > with pg_partman By default proc() does not detach tables concurrently. > How > > do we implement tables detach concurrently without blocking other > sessions > > Here queries not using date column to detach tables with > > run_maintenance_proc() which is not using concurrently based on the > > retention policy which leads to scan all available child tables hence > need > > to trigger this proc with concurrently option to avoid blocking other > child > > tables beyond rentention policy while running statements on them > > You might have more success by filing pg_partman issues at > https://github.com/pgpartman/pg_partman/issues > > > Do we have any other alternative rather than using pg_partman()? > > Well you can just run the same commands manually that pg_partman would > run. > > Christoph > Hi You might have more success by filing pg_partman issues at https://github.com/pgpartman/pg_partman/issues >>> okay My intention is to have any other extension other than pg_partman to manage table partitions manually Regards Durga Mahesh ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() @ 2024-07-22 04:59 Muhammad Imtiaz <[email protected]> parent: Durgamahesh Manne <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Muhammad Imtiaz @ 2024-07-22 04:59 UTC (permalink / raw) To: Durgamahesh Manne <[email protected]>; +Cc: Christoph Berg <[email protected]>; [email protected]; [email protected] Hi , You can consider the pg_pathman extension. *Muhammad Imtiaz* *PostgreSQL Technical Support Lead * */ Pakistan R&D* *Mobile: +923345072521* *Email: [email protected] <[email protected]>* On Fri, Jul 19, 2024 at 7:55 PM Durgamahesh Manne <[email protected]> wrote: > > > On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg <[email protected]> wrote: > >> Re: Durgamahesh Manne >> > with pg_partman By default proc() does not detach tables concurrently. >> How >> > do we implement tables detach concurrently without blocking other >> sessions >> > Here queries not using date column to detach tables with >> > run_maintenance_proc() which is not using concurrently based on the >> > retention policy which leads to scan all available child tables hence >> need >> > to trigger this proc with concurrently option to avoid blocking other >> child >> > tables beyond rentention policy while running statements on them >> >> You might have more success by filing pg_partman issues at >> https://github.com/pgpartman/pg_partman/issues >> >> > Do we have any other alternative rather than using pg_partman()? >> >> Well you can just run the same commands manually that pg_partman would >> run. >> >> Christoph >> > > Hi > You might have more success by filing pg_partman issues at > https://github.com/pgpartman/pg_partman/issues >>> okay > My intention is to have any other extension other than pg_partman to > manage table partitions manually > > Regards > Durga Mahesh > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-07-22 04:59 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-07-19 14:25 Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() Christoph Berg <[email protected]> 2024-07-19 14:56 ` Durgamahesh Manne <[email protected]> 2024-07-22 04:59 ` Muhammad Imtiaz <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox