From: PFC <lists@peufeu.com>
To: Marcos <mjs_ops@gmx.net>
To: pgsql-performance@postgresql.org
Subject: Re: Creating a correct and real benchmark
Date: Tue, 21 Feb 2006 01:14:27 +0100
Message-ID: <op.s5aqydincigqcu@apollo13> (raw)
In-Reply-To: <1140432636.1170.6.camel@servidor>
References: <1140432636.1170.6.camel@servidor>
> I'm developing a search engine using the postgresql's databas. I've
> already doing some tunnings looking increase the perform.
>
> Now, I'd like of do a realistic test of perfom with number X of queries
> for know the performance with many queries.
>
> What the corret way to do this?
I guess the only way to know how it will perform with your own
application is to benchmark it with queries coming from your own
application. You can create a test suite with a number of typical queries
and use your favourite scripting language to spawn a number of threads and
hammer the database. I find it interesting to measure the responsiveness
of the server while torturing it, simply by measuring the time it takes to
respond to a simple query and graphing it. Also you should not have N
threads issue the exact same queries, because then you will hit a too
small dataset. Introduce some randomness in the testing, for instance.
Benchmarking from another machine makes sure the test client's CPU usage
is not a part of the problem.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@peufeu.com, mjs_ops@gmx.net
Subject: Re: Creating a correct and real benchmark
In-Reply-To: <op.s5aqydincigqcu@apollo13>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox