performance regression when filling in a table

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема performance regression when filling in a table
Дата
Msg-id alpine.DEB.2.21.1904300653150.29712@lancre
обсуждение исходный текст
Ответы Re: performance regression when filling in a table  (Andres Freund <andres@anarazel.de>)
Список 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.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: generate documentation keywords table automatically