Re: pg_dump from v13 is slow

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_dump from v13 is slow
Date: 2020-08-14 01:04:11
Message-ID: 539630.1597367051@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Justin Pryzby <pryzby(at)telsasoft(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2020-08-14 01:05:26 Re: security_context_t marked as deprecated in libselinux 3.1
Previous Message Thomas Munro 2020-08-14 01:04:03 Re: fixing old_snapshot_threshold's time->xid mapping