performance regression when filling in a table

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: performance regression when filling in a table
Date: 2019-04-30 05:12:03
Message-ID: alpine.DEB.2.21.1904300653150.29712@lancre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hello devs,

On my SSD Ubuntu laptop, with postgres-distributed binaries and unmodified
default settings using local connections:

## pg 11.2
> time pgbench -i -s 100
...
done in 31.51 s
# (drop tables 0.00 s, create tables 0.01 s, generate 21.30 s, vacuum 3.32 s, primary keys 6.88 s).
# real 0m31.524s

## pg 12devel (cd3e2746)
> time pgbench -i -s 100
# done in 38.68 s
# (drop tables 0.00 s, create tables 0.02 s, generate 29.70 s, vacuum 2.92 s, primary keys 6.04 s).
real 0m38.695s

That is an overall +20% regression, and about 40% on the generate phase
alone. This is not a fluke, repeating the procedure shows similar results.

Is it the same for other people out there, or is it only something related
to my setup?

What change could explain such a significant performance regression?

--
Fabien.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2019-04-30 06:02:35 Re: generate documentation keywords table automatically
Previous Message Tom Lane 2019-04-30 04:50:20 Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6