Feedback-ID: id4a34324:Fastmail
Date: Mon, 21 Nov 2022 12:18:18 -0800
From: Andres Freund <andres@anarazel.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@lists.postgresql.org
Subject: Re: pgsql: Prevent instability in contrib/pageinspect's regression
 test.
Message-ID: <20221121201818.u32xtvpqc5wd6tx7@alap3.anarazel.de>
References: <E1ox94a-000EHu-VH@gemulon.postgresql.org>
 <20221121172206.h6kywxrzqcmhoqom@awork3.anarazel.de>
 <3214376.1669051457@sss.pgh.pa.us>
 <3215927.1669052115@sss.pgh.pa.us>
 <CA+TgmoaYMUv1ab2vAh7AoSUqUYHtPx9Cmehue2=JCXO3gvsDbw@mail.gmail.com>
 <20221121195628.2rlqpbkjgjsvqn6w@alap3.anarazel.de>
 <3264594.1669061535@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <3264594.1669061535@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/20221121201818.u32xtvpqc5wd6tx7%40alap3.anarazel.de>
Precedence: bulk

Hi,

On 2022-11-21 15:12:15 -0500, Tom Lane wrote:
> If I were trying to find a better fix I'd be looking for ways for
> parallel workers to be able to read the parent's temp tables.
> (Perhaps that could tie in with the blue-sky discussion we had
> the other day about allowing autovacuum on temp tables??)

That'd be a nontrivial change, because we explicitly don't use any
locking for anything relating to localbuf.c. One possible benefit could
be that we could substantially reduce the code duplication between
"normal" bufmgr.c and localbuf.c.

Greetings,

Andres Freund