New features for pgbench
От | Greg Smith |
---|---|
Тема | New features for pgbench |
Дата | |
Msg-id | Pine.GSO.4.64.0702112010320.9280@westnet.com обсуждение исходный текст |
Ответы |
Re: New features for pgbench
Re: New features for pgbench |
Список | pgsql-patches |
The attached adds two new command line switches to pgbench: -x: Generate extended detail in the latency log, including a timestamp for each transaction -X: Do extra cleanup after the run (vacuum on all tables, checkpoint) before stopping the clock. This gives substantially more consistancy in results between runs. Most pgbench results I see people present are so short that they're skewed considerably by whether there was a checkpoint in the middle of the run. This also allows testing situations with various autovacuum settings fairly. There's an update to the README describing the features, as well as correcting/extending some of the existing documentation. I generated the patch from the 8.2.3 release. Since pgbench runs the same way unless you pass it one of the new flags, I was hoping this would be considered for the next 8.2 update. I have a series of additional scripts I'll be releasing shortly that do interesting analysis of this extended latency data from pgbench (graphs of TPS and latency, that sort of thing), and I'd hate for that to only be available on 8.3. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
Вложения
В списке pgsql-patches по дате отправления: