Hello Andres,
The effect is that the first generation seems to take more time, but
dropping the table and regenerating again much less, with a typical 40%
performance improvement between first and second run, independently of the
version. The reported figures above where comparisons between fi
Hi,
On 2019-04-30 12:32:13 +0200, Fabien COELHO wrote:
> The effect is that the first generation seems to take more time, but
> dropping the table and regenerating again much less, with a typical 40%
> performance improvement between first and second run, independently of the
> version. The report
Hello Andres,
## pg 11.2 done in 31.51 s
## pg 12devel (cd3e2746) real0m38.695s
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
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,
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
