Re: Experimenting with hash tables inside pg_dump

From: "Bossart, Nathan" <bossartn(at)amazon(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Experimenting with hash tables inside pg_dump
Date: 2021-10-21 23:13:11
Message-ID: 45F7711B-CBA9-4D88-95B9-36FF815E4064@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 10/21/21, 3:29 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Dilger 2021-10-21 23:21:09 Re: CREATEROLE and role ownership hierarchies
Previous Message Bossart, Nathan 2021-10-21 23:04:34 Re: CREATEROLE and role ownership hierarchies