From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
Cc: | PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: performance regression when filling in a table |
Date: | 2019-04-30 07:13:37 |
Message-ID: | 20190430071337.jyos34diujjkvdrk@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
On 2019-04-30 07:12:03 +0200, Fabien COELHO wrote:
> 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?
I think the pre-release packages have had assertions enabled at some
point. I suggest checking that. If it's not that, profiles would be
helpful.
Greetings,
Andres Freund
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2019-04-30 09:03:15 | ERROR: failed to add item to the index page |
Previous Message | Andres Freund | 2019-04-30 07:05:52 | Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6 |