From: Boyer, Maxime (he/him | il/lui) <Maxime.Boyer@cra-arc.gc.ca>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Alexander Lakhin <exclusion@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andres Freund <andres@anarazel.de>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: RE: BUG #18165: Could not duplicate handle for "Global/PostgreSQL.xxxxxxxxxx": Bad file descriptor
Date: Tue, 24 Oct 2023 19:12:30 +0000
Message-ID: <9a0da706031f412c8119258f58ce3bf6@cra-arc.gc.ca> (raw)
In-Reply-To: <CA+hUKG+aTCoP7Um6WuyE_TV=2ftH6r3qOATVV+e2bzpOQhwnmQ@mail.gmail.com>
References: <18165-bf4f525cea6e51de@postgresql.org>
<3998077.1697840164@sss.pgh.pa.us>
<20231020225433.yhcw4qjbeixpgglh@awork3.anarazel.de>
<4019765.1697851177@sss.pgh.pa.us>
<CA+hUKG+W8cPyMpRNoao_bsKBH-2=1KM59sSPh-c3kA=TDyWeVw@mail.gmail.com>
<CA+hUKGJCQKTeAVDXRvsLeEwh=H2-NGoy7DaVcwxOsR9638ZniA@mail.gmail.com>
<CA+hUKG+gFC2LT7NW76k=EVJEUwa7nWgma=Y6hthzxQRW0JXQAg@mail.gmail.com>
<b8ee2352-4866-b8ef-5d94-e267104bab37@gmail.com>
<16e2bc6a6ebf4bd69bf81f6de135253d@cra-arc.gc.ca>
<CA+hUKG+aTCoP7Um6WuyE_TV=2ftH6r3qOATVV+e2bzpOQhwnmQ@mail.gmail.com>
Categorization:
Unclassified
Thank you all! :) I changed the setting back to 0 and we're not getting the error anymore. I have another error from pg11 I'll submit a new bug for.
Maxime
-----Original Message-----
From: Thomas Munro <thomas.munro@gmail.com>
Sent: October 21, 2023 5:29 PM
To: Boyer, Maxime (he/him | il/lui) <Maxime.Boyer@cra-arc.gc.ca>
Cc: Alexander Lakhin <exclusion@gmail.com>; Tom Lane <tgl@sss.pgh.pa.us>; Andres Freund <andres@anarazel.de>; pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18165: Could not duplicate handle for "Global/PostgreSQL.xxxxxxxxxx": Bad file descriptor
On Sun, Oct 22, 2023 at 4:38 AM Boyer, Maxime (he/him | il/lui) <Maxime.Boyer@cra-arc.gc.ca> wrote:
> You guys are good! I did set min_dynamic_shared_memory to 2 GB in the new config, which didn't exist on 11. I can set it to 0 and give it a try on Tuesday. Does 2 GB seem overkill? We have plenty of memory to go by.
Apparently it has never worked on Windows and you're the first to notice and report that, so we can't expect anyone to have platform-specific experience with that. But on other OSes we've seen it improve performance of large parallel joins and parallel vacuum, especially when 'huge pages' are configured. (Note that we had reports that our huge page support for windows stopped working on recent Windows versions, addressed in PostgreSQL 16 by commit fdd8937c, so YMMV on PostgreSQL 14.)
Thanks for the report, and to Alexander for testing. I've pushed the fix now, so it will ship in the next point release in a few weeks. In the meantime, the workaround is to set it to 0.
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-bugs@postgresql.org
Cc: Maxime.Boyer@cra-arc.gc.ca, thomas.munro@gmail.com, exclusion@gmail.com, tgl@sss.pgh.pa.us, andres@anarazel.de, pgsql-bugs@lists.postgresql.org
Subject: RE: BUG #18165: Could not duplicate handle for "Global/PostgreSQL.xxxxxxxxxx": Bad file descriptor
In-Reply-To: <9a0da706031f412c8119258f58ce3bf6@cra-arc.gc.ca>
* 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