Re: Experimenting with hash tables inside pg_dump - Mailing list pgsql-hackers

From Bossart, Nathan
Subject Re: Experimenting with hash tables inside pg_dump
Date
Msg-id 45F7711B-CBA9-4D88-95B9-36FF815E4064@amazon.com
Whole thread Raw
In response to Experimenting with hash tables inside pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 10/21/21, 3:29 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> (b) I couldn't measure any change in performance at all.  I tried
> it on the regression database and on a toy DB with 10000 simple
> tables.  Maybe on a really large DB you'd notice some difference,
> but I'm not very optimistic now.

I wonder how many tables you'd need to start seeing a difference.
There are certainly databases out there with many more than 10,000
tables.  I'll look into this...

Nathan


pgsql-hackers by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: Re: CREATEROLE and role ownership hierarchies
Next
From: Mark Dilger
Date:
Subject: Re: CREATEROLE and role ownership hierarchies