public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dilip Kumar <[email protected]>
To: Robert Haas <[email protected]>
Cc: Andrew Dunstan <[email protected]>
Cc: Heikki Linnakangas <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints
Date: Thu, 10 Feb 2022 18:02:31 +0530
Message-ID: <CAFiTN-syN3aqTo1RFUgCTNAiYVJCTEEDzBAA1UG70W3eULVCFg@mail.gmail.com> (raw)
In-Reply-To: <CA+TgmoZKn6_zbJW=ZPf6cp8HyWXk1uydppPymN0DxC4O04WP0g@mail.gmail.com>
References: <CAFiTN-sP6yLVTfjR42mEfvFwJ-SZ2iEtG1t0j=QX09X=BM+KWQ@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<CAFiTN-twdCWcUaMp_+15HFFL6LgUrjss0bVyh3M8ay=n9FD6xQ@mail.gmail.com>
	<[email protected]>
	<CAFiTN-tFm3Ecp=LiNQSQv0j7VR22UBb5tQNa+iUUqTggi4_sEA@mail.gmail.com>
	<CA+TgmoZKn6_zbJW=ZPf6cp8HyWXk1uydppPymN0DxC4O04WP0g@mail.gmail.com>

On Wed, Feb 9, 2022 at 9:31 PM Robert Haas <[email protected]> wrote:
>
> On Wed, Feb 9, 2022 at 10:59 AM Dilip Kumar <[email protected]> wrote:
> > On Wed, Feb 9, 2022 at 9:25 PM Andrew Dunstan <[email protected]> wrote:
> > > On 6/16/21 03:52, Dilip Kumar wrote:
> > > > On Tue, Jun 15, 2021 at 7:01 PM Andrew Dunstan <[email protected]> wrote:
> > > >> Rather than use size, I'd be inclined to say use this if the source
> > > >> database is marked as a template, and use the copydir approach for
> > > >> anything that isn't.
> > > > Yeah, that is possible, on the other thought wouldn't it be good to
> > > > provide control to the user by providing two different commands, e.g.
> > > > COPY DATABASE for the existing method (copydir) and CREATE DATABASE
> > > > for the new method (fully wal logged)?
> > >
> > > This proposal seems to have gotten lost.
> >
> > Yeah, I am planning to work on this part so that we can support both methods.
>
> But can we pick a different syntax? In my view this should be an
> option to CREATE DATABASE rather than a whole new command.

Maybe we can provide something like

CREATE DATABASE..WITH WAL_LOG=true/false ? OR
CREATE DATABASE..WITH WAL_LOG_DATA_PAGE=true/false ? OR
CREATE DATABASE..WITH CHECKPOINT=true/false ? OR

And then we can explain in documentation about these options?  I think
default should be new method?


--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

view thread (3+ messages)

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]
  Subject: Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints
  In-Reply-To: <CAFiTN-syN3aqTo1RFUgCTNAiYVJCTEEDzBAA1UG70W3eULVCFg@mail.gmail.com>

* 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