X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F2963329E45 for ; Thu, 23 Sep 2004 14:37:09 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20093-03 for ; Thu, 23 Sep 2004 13:36:59 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.205]) by svr1.postgresql.org (Postfix) with ESMTP id AECF9329E46 for ; Thu, 23 Sep 2004 14:36:59 +0100 (BST) Received: by mproxy.gmail.com with SMTP id 73so1982930rnk for ; Thu, 23 Sep 2004 06:36:47 -0700 (PDT) Received: by 10.38.208.40 with SMTP id f40mr19922rng; Thu, 23 Sep 2004 06:36:46 -0700 (PDT) Received: by 10.38.86.80 with HTTP; Thu, 23 Sep 2004 06:36:45 -0700 (PDT) Message-ID: <4b09a0c040923063623570662@mail.gmail.com> Date: Thu, 23 Sep 2004 15:36:45 +0200 From: Jean-Max Reymond Reply-To: Jean-Max Reymond To: Cao Van Khanh Subject: Re: PostgreSQL performence test tool Cc: pgsql-admin In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/221 X-Sequence-Number: 14924 ----- Original Message ----- From: Cao Van Khanh Date: Wed, 22 Sep 2004 10:11:18 +0700 Subject: [ADMIN] PostgreSQL performence test tool To: pgsql-admin 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