Re: Autovacuum of independent tables - Mailing list pgsql-general

From Michael Holzman
Subject Re: Autovacuum of independent tables
Date
Msg-id CAPNViJoWNJM=rwWfkGoxT=TJ37jDm3jf1gZvc6muEv33gFd_jQ@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum of independent tables  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general

On Tue, Sep 8, 2020 at 6:33 PM Magnus Hagander  wrote:

Per his session list, 11.2.
11.2 is on my personal testing machine. The real tests run with 12.1

Oh, now *cursors* is definitely something I didn't think of. And especially in the context of ODBC, I wonder if it might be creating cursors transparently, and that this somehow causes the problems.

Michael, do you know if that might be the case? Or try enabling log_statements to check if it is?
This is very interesting. I'll try to check it. I'll post here a reply if we do have open cursors. Thanks.
 
--
Regards,
    Michael Holzman

pgsql-general by date:

Previous
From: Michael Holzman
Date:
Subject: Re: Autovacuum of independent tables
Next
From: "J . Mageshwaran"
Date:
Subject: Network performance optimization