Thread: postgres benchmarking

Hello,

I checked in the docs and forums and couldn't find exactly what I wanted, so I figured I'd ask around here. Are there any good programs (specifically portable ones) for doing fairly intense benchmarking of postgres?

Mostly, I'm interested in getting performance numbers from different hardware configurations (32-bit vs. 64-bit, different disk systems). I'm building some new servers and I'd like to see if it's really worth it to splurge a little for faster disks.

Thanks,
Peter

You can try out some of the projects listed in pgfoundry.

one of them - http://pgfoundry.org/projects/benchmarksql/

- Vishal


>From: "Peter Koczan" <pjkoczan@gmail.com>
>To: pgsql-admin <pgsql-admin@postgresql.org>
>Subject: [ADMIN] postgres benchmarking
>Date: Tue, 26 Jun 2007 14:46:56 -0500
>
>Hello,
>
>I checked in the docs and forums and couldn't find exactly what I wanted,
>so
>I figured I'd ask around here. Are there any good programs (specifically
>portable ones) for doing fairly intense benchmarking of postgres?
>
>Mostly, I'm interested in getting performance numbers from different
>hardware configurations (32-bit vs. 64-bit, different disk systems). I'm
>building some new servers and I'd like to see if it's really worth it to
>splurge a little for faster disks.
>
>Thanks,
>Peter

_________________________________________________________________
Like puzzles? Play free games & earn great prizes. Play Clink now.
http://club.live.com/clink.aspx?icid=clink_hotmailtextlink2