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
In-reply-to: 
 <CAKDb7aGEru90ksWBuregR=Qw=oNpCt7F-VWfu4mx4c9hwYTjUQ@mail.gmail.com>
References: 
 <CAKDb7aGEru90ksWBuregR=Qw=oNpCt7F-VWfu4mx4c9hwYTjUQ@mail.gmail.com>
Comments: In-reply-to ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>
	message dated "Sun, 25 Jun 2023 14:21:28 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <509156.1687703470.1@sss.pgh.pa.us>
Date: Sun, 25 Jun 2023 10:31:10 -0400
Message-ID: <509157.1687703470@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/509157.1687703470%40sss.pgh.pa.us>
Precedence: bulk

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