Re: Experimenting with hash tables inside pg_dump

Поиск
Список
Период
Сортировка
От Bossart, Nathan
Тема Re: Experimenting with hash tables inside pg_dump
Дата
Msg-id D6786BAE-DD4D-4972-AC97-531CFE79FDC4@amazon.com
обсуждение исходный текст
Ответ на Re: Experimenting with hash tables inside pg_dump  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On 10/21/21, 4:14 PM, "Bossart, Nathan" <bossartn@amazon.com> wrote:
> 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...

Well, I tested with 200,000 tables and saw no difference with this.

Nathan


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Experimenting with hash tables inside pg_dump
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Experimenting with hash tables inside pg_dump