pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Fix buffer refcount leak with FDW bulk inserts 2+ messages / 2 participants [nested] [flat]
* Fix buffer refcount leak with FDW bulk inserts @ 2023-06-25 08:51 ROHIT SACHDEVA <sachdeva.rohit648@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: ROHIT SACHDEVA @ 2023-06-25 08:51 UTC (permalink / raw) To: pgsql-admin@lists.postgresql.org 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Fix buffer refcount leak with FDW bulk inserts @ 2023-06-25 14:31 Tom Lane <tgl@sss.pgh.pa.us> parent: ROHIT SACHDEVA <sachdeva.rohit648@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2023-06-25 14:31 UTC (permalink / raw) To: ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-06-25 14:31 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-06-25 08:51 Fix buffer refcount leak with FDW bulk inserts ROHIT SACHDEVA <sachdeva.rohit648@gmail.com> 2023-06-25 14:31 ` Tom Lane <tgl@sss.pgh.pa.us>
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