Fix buffer refcount leak with FDW bulk inserts

From: ROHIT SACHDEVA <sachdeva(dot)rohit648(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Fix buffer refcount leak with FDW bulk inserts
Date: 2023-06-25 08:51:28
Message-ID: CAKDb7aGEru90ksWBuregR=Qw=oNpCt7F-VWfu4mx4c9hwYTjUQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team,

I am using postgres 14 version and I am using fdw.

Error
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

What is the impact of this error should I perform the insertion again.

Let me asap.

--
Have a Good day !!!

Regards
Rohit Sachdeva

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2023-06-25 14:31:10 Re: Fix buffer refcount leak with FDW bulk inserts
Previous Message Julien Rouhaud 2023-06-23 23:36:26 Re: Temp getting written to disk despite being smaller than temp_buffers?