| From: | "Bossart, Nathan" <bossartn(at)amazon(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "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:59:57 |
| Message-ID: | D6786BAE-DD4D-4972-AC97-531CFE79FDC4@amazon.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 10/21/21, 4:14 PM, "Bossart, Nathan" <bossartn(at)amazon(dot)com> wrote:
> 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...
Well, I tested with 200,000 tables and saw no difference with this.
Nathan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-10-22 00:22:56 | Re: Experimenting with hash tables inside pg_dump |
| Previous Message | Andres Freund | 2021-10-21 23:37:57 | Re: Experimenting with hash tables inside pg_dump |