Re: Autovacuum of independent tables

From: Michael Holzman <michaelholzman(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: Autovacuum of independent tables
Date: 2020-09-08 10:13:14
Message-ID: CAPNViJoV+Bpgja8vEES2dnes-aHSbm_vxQZcmWOi+ZbrK2JhqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 8, 2020 at 12:28 PM Pavel Stehule wrote:

>
> You can try to reduce length of transactions, if possible.
>
>
> This is the problem. A and B were developed for Oracle where SELECT does
not open a transaction. We moved them to PG and now we have to very
accurately add COMMITs without breaking the flow. It is quite a complex
thing. I hoped we can avoid that.

--
Regards,
Michael Holzman

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2020-09-08 10:52:10 Re: Autovacuum of independent tables
Previous Message Pavel Stehule 2020-09-08 09:27:44 Re: Autovacuum of independent tables