Re: Improvements in pg_dump/pg_restore toc format and performances

From: Pierre Ducroquet <p(dot)psql(at)pinaraf(dot)info>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Improvements in pg_dump/pg_restore toc format and performances
Date: 2023-09-19 10:15:55
Message-ID: 2575263.Lt9SDvczpP@peanuts2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Monday, September 18, 2023 11:54:42 PM CEST Nathan Bossart wrote:
> On Mon, Sep 18, 2023 at 02:52:47PM -0700, Nathan Bossart wrote:
> > On Thu, Jul 27, 2023 at 10:51:11AM +0200, Pierre Ducroquet wrote:
> >> I ended up writing several patches that shaved some time for pg_restore
> >> -l,
> >> and reduced the toc.dat size.
> >
> > I've only just started taking a look at these patches, and I intend to do
> > a
> > more thorough review in the hopefully-not-too-distant future.
> Since cfbot is failing on some pg_upgrade and pg_dump tests, I've set this
> to waiting-on-author.

Attached updated patches fix this regression, I'm sorry I missed that.

Attachment Content-Type Size
0001-drop-has-oids-field-instead-of-having-static-values.patch text/x-patch 1.7 KB
0002-convert-sscanf-to-strtoul.patch text/x-patch 1.2 KB
0003-store-oids-as-integer-instead-of-string.patch text/x-patch 3.3 KB
0004-move-static-strings-to-arrays-at-beginning.patch text/x-patch 10.0 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2023-09-19 10:18:37 Re: Move bki file pre-processing from initdb to bootstrap
Previous Message Matthias van de Meent 2023-09-19 10:07:07 Re: XLog size reductions: Reduced XLog record header size for PG17