public inbox for [email protected]
help / color / mirror / Atom feedFrom: Nathan Bossart <[email protected]>
To: Andres Freund <[email protected]>
Cc: Michael Paquier <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: Thomas Munro <[email protected]>
Cc: Fujii Masao <[email protected]>
Cc: Postgres hackers <[email protected]>
Subject: Re: Weird failure with latches in curculio on v15
Date: Sun, 5 Feb 2023 16:46:31 -0800
Message-ID: <20230206004631.GA277434@nathanxps13> (raw)
In-Reply-To: <[email protected]>
References: <20230201175806.GA3199959@nathanxps13>
<20230201223555.GA3721373@nathanxps13>
<[email protected]>
<[email protected]>
<20230204180354.GA258107@nathanxps13>
<[email protected]>
<20230205221938.GA274245@nathanxps13>
<[email protected]>
<20230205235747.GA275913@nathanxps13>
<[email protected]>
On Sun, Feb 05, 2023 at 04:07:50PM -0800, Andres Freund wrote:
> On 2023-02-05 15:57:47 -0800, Nathan Bossart wrote:
>> I agree that the shell overhead isn't the main performance issue,
>> but it's unclear to me how much of this should be baked into
>> PostgreSQL.
>
> I don't know fully either. But just reimplementing all of it in
> different modules doesn't seem like a sane approach either. A lot of it
> is policy that we need to solve once, centrally.
>
>> I mean, we could introduce a GUC that tells us how far ahead to
>> restore and have a background worker (or multiple background workers)
>> asynchronously pull files into a staging directory via the callbacks.
>> Is that the sort of scope you are envisioning?
>
> Closer, at least.
Got it. I suspect we'll want to do something similar for archive modules
eventually, too.
--
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
view thread (15+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Weird failure with latches in curculio on v15
In-Reply-To: <20230206004631.GA277434@nathanxps13>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox