public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Ellen Allhatatlan <[email protected]>
To: Justin <[email protected]>
Cc: Merlin Moncure <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: MVCC and all that...
Date: Wed, 10 Sep 2025 07:46:29 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAMLfE0O5YPhrXOWP1pLTLHy-rKDut5cmiGyuxo3d43LCGEkJYg@mail.gmail.com>
References: <CAMLfE0MAVH5YORs0OKmD=fFWH9EtuNsnhViti=+hkp3Kbz-Gfw@mail.gmail.com>
<CAHyXU0yrwoEYia0mZhpjQLMdd-WXpWFM+Au1jXQpk3MtBvdogw@mail.gmail.com>
<CAMLfE0MWqALMJ99dpFniZ1xknCgHj4ETPWro+Ry9awPUG1OKMw@mail.gmail.com>
<CAHyXU0y2gZfH_ZomazQB7H0KkuyV3QofvuvZcSYXEhpotG=hMA@mail.gmail.com>
<CALL-XeM=0oH=2ECawmyCOv2umKF1nyqr97CuQXiPfO39uhCucQ@mail.gmail.com>
<CAMLfE0O5YPhrXOWP1pLTLHy-rKDut5cmiGyuxo3d43LCGEkJYg@mail.gmail.com>
On 9/10/25 00:41, Ellen Allhatatlan wrote:
> Hi, and thanks for your input,
>
>> The author brings up threaded vs multi-process. That's an old old old old old conversation that has been shown there is no clear better way.
>
> This is where things become interesting. Firebird actually has 3
> process/threading models - and they manage to maintain these with a
> team that is *_much_* smaller than the PostgreSQL one - FB is a minnow
> compared to PG!
Though I would like to know what happened in mid 2010?:
https://github.com/FirebirdSQL/firebird/graphs/contributors
>
>> Backup argument is cherry picking and not discussing pgBackrest and other solutions or the use of tablespaces to isolate databases in a cluster at the disk layer or disk snapshots.
>
> OK again. I'm just wondering if the single file per database isn't a
> fundamental architectural flaw in itself? AIUI, you could have
> mulitple files (back in 32-bit land) "chained" - but (again AIUI) the
> same table could be spread over x files - all "intermingled"... weird.
>
What are you referring to above?
At any rate from the article:
"pg_basebackup always dumps the entire cluster, when restoring one
database, your entire PostgreSQL cluster will be restored, which will
contain only one database. The files of all your other databases will be
zero size."
AFAIK there is no option to restore one database with pg_basebackup.
I think the author is referring to pgBackRest:
https://pgbackrest.org/user-guide.html#restore/option-db-include
" The test1 database, despite successful recovery, is not accessible.
This is because the entire database was restored as sparse, zeroed files."
--
Adrian Klaver
[email protected]
view thread (21+ 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]
Subject: Re: MVCC and all that...
In-Reply-To: <[email protected]>
* 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