Re: Patch: dumping tables data in multiple chunks in pg_dump - Mailing list pgsql-hackers

From Zsolt Parragi
Subject Re: Patch: dumping tables data in multiple chunks in pg_dump
Date
Msg-id CAN4CZFN=iKYAhaki0eC-ADutk-aB3B5jOV26FrTewWouQiD6jQ@mail.gmail.com
Whole thread
In response to Re: Patch: dumping tables data in multiple chunks in pg_dump  (Hannu Krosing <hannuk@google.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: remove bits* types
Next
From: Sami Imseih
Date:
Subject: Re: [PATCH] pg_stat_statements: add last_execution_start column