Postgres Pro
Downloads
Home   >   mailing lists

Re: Fix buffer refcount leak with FDW bulk inserts - Mailing list pgsql-admin

From Tom Lane
Subject Re: Fix buffer refcount leak with FDW bulk inserts
Date
Msg-id 509157.1687703470@sss.pgh.pa.us
Whole thread Raw
In response to Fix buffer refcount leak with FDW bulk inserts  (ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: ROHIT SACHDEVA
Date:
Subject: Fix buffer refcount leak with FDW bulk inserts
Next
From: Deo Felix
Date:
Subject: Postgresql Database cant start after restore using pgBackRest