From: Tom Lane <tgl@sss.pgh.pa.us>
To: ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Fix buffer refcount leak with FDW bulk inserts
Date: Sun, 25 Jun 2023 10:31:10 -0400
Message-ID: <509157.1687703470@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKDb7aGEru90ksWBuregR=Qw=oNpCt7F-VWfu4mx4c9hwYTjUQ@mail.gmail.com>
References: <CAKDb7aGEru90ksWBuregR=Qw=oNpCt7F-VWfu4mx4c9hwYTjUQ@mail.gmail.com>
ROHIT SACHDEVA <sachdeva.rohit648@gmail.com> writes:
> When i am try to increase the batch_size parameter and do the insertion
> part i received this error.
> WARNING: buffer refcount leak: [1733373] (rel=base/19360/251000,
> blockNum=809
That's just a warning, not an error. It's pretty harmless.
> What is the impact of this error should I perform the insertion again.
No.
What you should do is update to the current minor release (14.8),
which contains a fix for a bug matching this symptom.
(If you can still reproduce the warning on 14.8, we'd be interested
to see a self-contained test case.)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, sachdeva.rohit648@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Fix buffer refcount leak with FDW bulk inserts
In-Reply-To: <509157.1687703470@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox