Re: pg_dump from v13 is slow - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump from v13 is slow
Date
Msg-id 539630.1597367051@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump from v13 is slow  (Justin Pryzby <pryzby@telsasoft.com>)
List 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 by date:

Previous
From: Thomas Munro
Date:
Subject: Re: fixing old_snapshot_threshold's time->xid mapping
Next
From: Michael Paquier
Date:
Subject: Re: security_context_t marked as deprecated in libselinux 3.1