Search Postgresql Archives

Re: Autovacuum of independent tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Autovacuum of independent tables
From: Michael Holzman <michaelholzman@xxxxxxxxx>
Date: Tue, 8 Sep 2020 13:13:14 +0300
Cc: Michael Paquier <michael@xxxxxxxxxxx>
In-reply-to: <CAFj8pRCH_P5YJZaLad1kTw-boGd=PGhY73BR=awLqpGtw3=0zg@mail.gmail.com>
References: <CAPNViJrQFge6EW_dvwaLB8pjRq4K51vnvcYBPNb8SuTW88MrBw@mail.gmail.com> <CAFj8pRD1=CUAhixyP5CGGsc=GOHFWX3oM22WFU6KnH1CAqN2YQ@mail.gmail.com> <CAPNViJrFNA8xiEgFeDoZ1GVKndx-MQXsES0Lg2hzrkNohzfJSA@mail.gmail.com> <20200908082755.GI19261@paquier.xyz> <CAPNViJo0eRP10-e0VRVgzh2xPobay5FpY2z5OOSLS_-jtasVRg@mail.gmail.com> <CAFj8pRCH_P5YJZaLad1kTw-boGd=PGhY73BR=awLqpGtw3=0zg@mail.gmail.com>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Autovacuum of independent tables
  - From: Ravi Krishna

References:
- Autovacuum of independent tables
  - From: Michael Holzman
- Re: Autovacuum of independent tables
  - From: Pavel Stehule
- Re: Autovacuum of independent tables
  - From: Michael Holzman
- Re: Autovacuum of independent tables
  - From: Michael Paquier
- Re: Autovacuum of independent tables
  - From: Michael Holzman
- Re: Autovacuum of independent tables
  - From: Pavel Stehule

Prev by Date: Re: Autovacuum of independent tables
Next by Date: Re: Autovacuum of independent tables
Previous by thread: Re: Autovacuum of independent tables
Next by thread: Re: Autovacuum of independent tables
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]