On Fri, Feb 13, 2009 at 4:48 AM, Ashish Karalkar <ashishka@xxxxxxxxxxxxx> wrote: > Ashish Karalkar wrote: >> >> Abdul Rahman wrote: >>> >>> Hi all, >>> >>> Can any body tell me about tool for PostgreSQL load testing preferably >>> freeware. >>> >>> Regards, >>> Abdul Rehman. >>> >> I am not sure its a freeware or not but looks promising >> >> http://bristlecone.continuent.org/HomePage >> >> >> --Ashish >> > And ofcourse the PGbench which is freeware: > > http://www.postgresql.org/docs/current/static/pgbench.html Yep. pgbench is kind of my basic acceptance testing benchmark. If you've got a 16 core 128G ram machine hitched onto a 100+15k5 SAS disk san array and you're getting 20 tps on pgbench there's not much use in running other benchmarks until you figure out what's so wrong. It's also good for applying burn in loads over long periods. Nothing like a week of running pgbench to find problems with RAID controllers, drives, memory, cpus, cooling, power supplies or kernels. I had a kernel bug on a server last year that took about 12 hours of heavy pgbench to show up. Had a bad RAID controller that took 24 to 36 hours of pgbench to hang. Plus, pgbench has the ability to run custom SQL for benchmarking, so it's an easy way to build a custom test. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
