On Fri, Mar 20, 2009 at 9:55 AM, Will Rutherdale (rutherw) <ruth...@cisco.com> wrote: > You have a point, as do a lot of the other folks. > > However, keeping the KISS principle in mind, you can create a benchmark > that simply sets up a sample database and forks off a bunch of processes > to do random updates for an hour, say. Dead simple. > > In fact, it's so simple that I've already written the code and have it > running against Postgres now. A Perl DBI script runs in a loop > updating, and later prints out the number of transactions it completed > in the given time frame. At the end I just tally up the numbers and I > have the Will Rutherdale benchmark number for Postgres. It will give me > a simple number in units of transactions per second.
Just keep in mind that a single thread updating the database is not a very realistic benchmark. Databases tend to not get interesting until there are dozens to hundreds of threads running against it at the same time. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
