X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B60109DCA4B for ; Wed, 15 Feb 2006 06:40:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87925-09 for ; Wed, 15 Feb 2006 06:40:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.androme.com (mail.androme.com [62.58.96.145]) by postgresql.org (Postfix) with ESMTP id 53ED49DC884 for ; Wed, 15 Feb 2006 06:40:18 -0400 (AST) Received: from [192.168.10.61] ([192.168.10.61]) by mail.androme.com (8.12.10/8.12.10) with ESMTP id k1FAeKDr007541 for ; Wed, 15 Feb 2006 11:40:20 +0100 Message-ID: <43F30514.9040907@andromeiberica.com> Date: Wed, 15 Feb 2006 11:40:20 +0100 From: Arnau Reply-To: arnaulist@andromeiberica.com User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: how test postgresql.conf settings? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.125 required=5 tests=[AWL=0.125] X-Spam-Score: 0.125 X-Spam-Level: X-Archive-Number: 200602/186 X-Sequence-Number: 20607 Hi all, I'm testing different configurations of postgresql 8.1 running on debian. The method I was following was: - change the postgresql.conf - restart postgres (/etc/init.d/postgresql restart ) - execute my test queries I have noticed that this is not enough to flush the cache, I don't know where it is, if at the raid controller, at OS or at postgresql itself. Reboot the machine I don't think it's a good solution because it takes quite long. Do you have any suggestion? BTW is there any tool to stress the DB, I mean, create a set of queries to execute and throw a configurable set of concurrent connections to check the performance? Thanks to all