Re: pg_dump from v13 is slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump from v13 is slow
Дата
Msg-id 539630.1597367051@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump from v13 is slow  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
Justin Pryzby <pryzby@telsasoft.com> writes:
> I can reproduce the issue with generated data:
> pryzbyj=# SELECT format('create table t%s(i int)', i) FROM generate_series(1,9999)i;

Hm, I tried this case and didn't really detect much runtime difference
between v12 and HEAD.

> I don't know if it's any issue, but I found that pg12 can process "null
> statements" almost 2x as fast:

Now I'm suspicious that you're comparing an assert-enabled v13 build
to a non-assert-enabled v12 build.  Check the output of
"pg_config --configure" from each installation to see if they're
configured alike.

            regards, tom lane



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: fixing old_snapshot_threshold's time->xid mapping
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: security_context_t marked as deprecated in libselinux 3.1