From: | Sathish Reddy <sathishreddy(dot)postgresql(at)gmail(dot)com> |
---|---|
To: | srinioracledba7(at)gmail(dot)com |
Cc: | keith(dot)fiske(at)crunchydata(dot)com, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Detach partition concurrently from pg cron |
Date: | 2024-07-09 06:25:19 |
Message-ID: | CA+M9Y+BBPR+Epcb4bf-7-dH+XFp1KTmXE0PpW=CXgv0GJFeKNg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Please share pg_cron syntax for individual partition detach concurrently
On Tue, Jul 9, 2024, 11:31 AM srinivasan s <srinioracledba7(at)gmail(dot)com>
wrote:
> We had a similar request and we have written a postgresql function to
> concurrently detach old partition in version 15, unfortunately we cannot
> use concurrently inside a postgresql function. We have to apply a logic and
> run individual detach commands for each partition via pg_cron.
>
>
>
> On Tue, 9 Jul, 2024, 9:55 am Sathish Reddy, <
> sathishreddy(dot)postgresql(at)gmail(dot)com> wrote:
>
>> Thanks for the advice.please help me on configure pg_cron schedule job
>> trigger from postgres database to another database will run job
>>
>> Thanks
>> Sathish Reddy
>>
>> On Mon, Jul 8, 2024, 6:46 PM Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com>
>> wrote:
>>
>>> On Mon, Jul 8, 2024 at 5:43 AM Sathish Reddy <
>>> sathishreddy(dot)postgresql(at)gmail(dot)com> wrote:
>>>
>>>> Hi
>>>> Please help me on partman detach partition concurrently using pg cron
>>>> run from postgres database to another database in detail.
>>>>
>>>> Thanks
>>>> Sathish Reddy
>>>>
>>>
>>> Concurrent detach is not possible with pg_partman at this time. No
>>> concurrent operations can be called within a function's transaction block.
>>>
>>> See this issue for more information -
>>> https://github.com/pgpartman/pg_partman/issues/387
>>>
>>> If you need to detach concurrently, you will have to use some separate
>>> process to do it at this time. Not sure if that can be done with pg_cron
>>> since I'm not sure if that is also doing its own calls within a functional
>>> transaction.
>>>
>>> --
>>> Keith Fiske
>>> Senior Database Engineer
>>> Crunchy Data - http://crunchydata.com
>>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Sbob | 2024-07-09 22:36:33 | OT: help with pgloader |
Previous Message | srinivasan s | 2024-07-09 06:01:04 | Re: Detach partition concurrently from pg cron |