On Mon, 17 Mar 2003, Nick Piggin wrote: > Dear PostgreSQL hackers, > I am developing a disk IO scheduler for Linux and am aiming to > have it included in the stable 2.6 release. Due to its design, > performance regressions do appear, and are often more specific > to the workload in question than with other schedulers, hence > one has to go beyond the generic benchmarks. > > Databases are one area of difficulty due to multi threaded IO > and sync writes. > > I would appreciate it if you could give me a suggestion > for a not-too-difficult to set up or interpret PostgreSQL > benchmark with a reasonable running time (< an hour or so) > which I can add to my performance regression tests. > > It would be good if this were to separately measure most > common types of PostgreSQL IO work, and from there I would > leave specific areas to those interested. > > I apologise for asking when I could search, however I am > interested in something up to date and which developers on > this can agree on.
For quick and dirty testing under high parallel load, you can use pgbench, which comes with postgres. cd /usr/local/src/postgresql-7.3.x/contrib/pgbench make make install pgbench -i pgbench -c 4 -t 100 For more intense testing, look at OSDB the Open Source database benchmark suite: http://osdb.sourceforge.net/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
