Search Postgresql Archives

Re: Load Testing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux