Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qiW3J-006ebn-9J for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Sep 2023 08:25:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qiW3H-007oaD-FX for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Sep 2023 08:25:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qiW3H-007oZe-2e for pgsql-hackers@lists.postgresql.org; Tue, 19 Sep 2023 08:25:47 +0000 Received: from rock.pinaraf.info ([109.190.54.247]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qiW3D-005PPG-U8 for pgsql-hackers@lists.postgresql.org; Tue, 19 Sep 2023 08:25:45 +0000 Received: from peanuts2.localnet (unknown [IPv6:2001:41d0:fc0b:e300:264b:feff:fe05:380b]) by rock.pinaraf.info (Postfix) with ESMTPSA id 4RqZTy3QKhz20KR; Tue, 19 Sep 2023 10:25:10 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=pinaraf.info; s=rock; t=1695111910; bh=HMCLsuZrE3EijEEGobfpK6C9dAykzseqayx1+boMe9I=; h=From:To:Cc:Subject:Date:In-Reply-To:References:From; b=TmhF9ut2K16/9XEZTcvSWTOzShpr1ycOz6/mQ9gDj1b9r1ZthCUKpwOylLFVAo8Az Q0iOSYek1HwFIRx8cU5THmcwgzdUBan5fiDu9nwC64twOssydx9oWJcVzrJwV3I7rI npaTmZ9du1CqxBBjAqYimGmQNn5kYlUfl0v+cpTo7PFILgNXSebroPuQXvleAaWQll fXOjJRfmz3VdR4BMhpeT15KXHUOJqZESlz8P4F67tMoxYTBc/gZ4+yf4gqILdUA0D0 B8qolxJN3WhNCmg5znmDyujdWZgWBiJDCyPdZaEu+RU8MLsmhyH8FDPbwagE7pIru0 mNmY5sjax/KQA== From: Pierre Ducroquet To: Nathan Bossart Cc: pgsql-hackers@lists.postgresql.org Subject: Re: Improvements in pg_dump/pg_restore toc format and performances Date: Tue, 19 Sep 2023 10:25:09 +0200 Message-ID: <1867814.CQOukoFCf9@peanuts2> In-Reply-To: <20230918215442.GB2661288@nathanxps13> References: <2656000.KRxA6XjA2N@peanuts2> <20230918215247.GA2661288@nathanxps13> <20230918215442.GB2661288@nathanxps13> MIME-Version: 1.0 Content-Transfer-Encoding: 7Bit Content-Type: text/plain; charset="us-ascii" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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. FYI, the failures are related to patch 0004, I said it was dirty, but it was apparently an understatement. Patches 0001 to 0003 don't exhibit any regression.