public inbox for [email protected]
help / color / mirror / Atom feedFrom: Zsolt Parragi <[email protected]>
To: Hannu Krosing <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Cc: David Rowley <[email protected]>
Cc: Michael Banck <[email protected]>
Cc: Ashutosh Bapat <[email protected]>
Cc: Nathan Bossart <[email protected]>
Subject: Re: Patch: dumping tables data in multiple chunks in pg_dump
Date: Mon, 30 Mar 2026 22:32:22 +0100
Message-ID: <CAN4CZFN=iKYAhaki0eC-ADutk-aB3B5jOV26FrTewWouQiD6jQ@mail.gmail.com> (raw)
In-Reply-To: <CAMT0RQT9v8sKiMK+BwMLNENrrBTpxnhTUOwmsvG9-YohAHQTjA@mail.gmail.com>
References: <CAMT0RQT_0qVxcTT6ycM20QUN-pEQ6iMLbz6gLWgLpeF0NmNOUA@mail.gmail.com>
<CAExHW5t54GPKFbW3KLzintJ6jMMRYwb-t2Fjm4JTxEcZbGDomA@mail.gmail.com>
<CAMT0RQTHoL8S7OonFWC_aDSC-2oX7BGBBLAQ+OOBhRPcxV2eiw@mail.gmail.com>
<CAMT0RQQAH1a8kY-mx7B07Uzn3T_zeaU9detqFFtW36_k67Su+A@mail.gmail.com>
<CAMT0RQQr7KtPAY903+F42csiHc1EPHo70Xji-znkxEhwdoKa6w@mail.gmail.com>
<CAMT0RQSNHFffbCmDNxQogVBD8H5gTDJNwhUR2btCVE+Lq1sGGw@mail.gmail.com>
<CAMT0RQTEFGctCfgVx3u2XgVRCAj_QURV2tfdzL0HOQi=u0sV2A@mail.gmail.com>
<CAApHDvr8ay+31Wd0TptDGp8cAg2-NOnWddx8csnUE3R03EbvZw@mail.gmail.com>
<[email protected]>
<CAMT0RQRtLwi_CrOcD7KxYL0Gm1nGXb-HWmerVg=ajEs6JP7m+w@mail.gmail.com>
<CAMT0RQTe4Zr=rdcKMJj-=c7CH0PJh=ZPk=xOU98+M7p9-D+Yew@mail.gmail.com>
<CAMT0RQSfEvhZB_3_UZamm+Oi9O7+4+XWi-OOL0NnctyvLZRS0g@mail.gmail.com>
<CAMT0RQT9v8sKiMK+BwMLNENrrBTpxnhTUOwmsvG9-YohAHQTjA@mail.gmail.com>
Hello!
A simple test causes an assertion failure in my testing, dependency
counting still doesn't seem to work correctly:
pg_restore: >...>/pg_backup_archiver.c:5207: reduce_dependencies:
Assertion `otherte->depCount > 0' failed.
Without assertions it results in data loss.
004_pg_dump_parallel also showcases the issue in my testing.
But simple manual testing also confirms it:
1. create some data
CREATE TABLE tplain (id int UNIQUE);
INSERT INTO tplain SELECT x FROM generate_series(1,1000) x;
2. create a dump
dump with --max-table-segment-pages=2
3. try to restore
restore with --jobs=3
view thread (34+ 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], [email protected], [email protected]
Subject: Re: Patch: dumping tables data in multiple chunks in pg_dump
In-Reply-To: <CAN4CZFN=iKYAhaki0eC-ADutk-aB3B5jOV26FrTewWouQiD6jQ@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