pgbench - allow to specify scale as a size

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
pgbench - allow to specify scale as a size
Дата
Msg-id
alpine.DEB.2.20.1802171013110.20813@lancre
Список
Дерево обсуждения
pgbench - allow to specify scale as a size Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to specify scale as a size Erik Rijkers <er@xs4all.nl>
Re: pgbench - allow to specify scale as a size Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to specify scale as a size Tom Lane <tgl@sss.pgh.pa.us>
Re: pgbench - allow to specify scale as a size Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to specify scale as a size Alvaro Hernandez <aht@ongres.com>
Re: pgbench - allow to specify scale as a size Tom Lane <tgl@sss.pgh.pa.us>
Re: pgbench - allow to specify scale as a size Alvaro Hernandez <aht@ongres.com>
Re: pgbench - allow to specify scale as a size Mark Wong <mark@2ndQuadrant.com>
Re: pgbench - allow to specify scale as a size Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to specify scale as a size Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to specify scale as a size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pgbench - allow to specify scale as a size Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to specify scale as a size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pgbench - allow to specify scale as a size Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to specify scale as a size Alvaro Hernandez <aht@ongres.com>
Re: pgbench - allow to specify scale as a size Fabien COELHO <coelho@cri.ensmp.fr>

After Karel Moppel piece on pgbench scale/size conversion, it occured to 
me that having this as an option would be nice.

https://www.cybertec-postgresql.com/en/a-formula-to-calculate-pgbench-scaling-factor-for-target-db-size/

Here is a attempt at extending --scale so that it can be given a size.

   pgbench -i --scale=124G ...

The approximated database size is also shown in the end-of-run summary.

-- 
Fabien.
В списке pgsql-hackers по дате отправления
От: Arthur Zakirov
Дата:
От: David Rowley
Дата:
FAQ