Thread: PostgreSQL performence test tool

PostgreSQL performence test tool

From
"Cao Van Khanh"
Date:

My work is making PostgreSQL run as fast as posible , but there’re a lot of  parameter . So I would like to have your help . When I change some parameter , I can not find out is better or not . I need some tool to test the perfomence of postgeSQL . Anyone could help me ?

Re: PostgreSQL performence test tool

From
"Scott Marlowe"
Date:
Take a look at OSDL.  PostgreSQL is their default database test
platform.

http://www.osdl.org/ or, more specifically, the dbt test suite site:

http://sourceforge.net/projects/osdldbt/

On Tue, 2004-09-21 at 21:11, Cao Van Khanh wrote:
> My work is making PostgreSQL run as fast as posible , but there’re a
> lot of  parameter . So I would like to have your help . When I change
> some parameter , I can not find out is better or not . I need some
> tool to test the perfomence of postgeSQL . Anyone could help me ?
>
>


Re: PostgreSQL performence test tool

From
Jean-Max Reymond
Date:
----- Original Message -----
From: Cao Van Khanh <cvkhanh@cmc.com.vn>
Date: Wed, 22 Sep 2004 10:11:18 +0700
Subject: [ADMIN] PostgreSQL performence test tool
To: pgsql-admin <pgsql-admin@postgresql.org>




My work is making PostgreSQL run as fast as posible , but there're a
lot of  parameter . So I would like to have your help . When I change
some parameter , I can not find out is better or not . I need some
tool to test the perfomence of postgeSQL . Anyone could help me ?

In the mailing list PERFORMANCE, you will have some help.
to begin, read :

http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

--
Jean-Max Reymond
CKR Solutions
http://www.ckr-solutions.com