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 16A999DC99D for ; Wed, 15 Feb 2006 06:39:58 -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 87006-09 for ; Wed, 15 Feb 2006 06:39:59 -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 9EA949DC9CE for ; Wed, 15 Feb 2006 06:39:54 -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 k1FAduDr007519 for ; Wed, 15 Feb 2006 11:39:56 +0100 Message-ID: <43F304FC.9040904@androme.es> Date: Wed, 15 Feb 2006 11:39:56 +0100 From: Arnau Rebassa Villalonga 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.08 required=5 tests=[AWL=0.080] X-Spam-Score: 0.08 X-Spam-Level: X-Archive-Number: 200602/222 X-Sequence-Number: 20643 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 -- Arnau