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
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 |