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 462AF9DCB60 for ; Sun, 19 Feb 2006 00:06:44 -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 89215-02 for ; Sun, 19 Feb 2006 00:06:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by postgresql.org (Postfix) with ESMTP id 800DB9DCB5B for ; Sun, 19 Feb 2006 00:06:41 -0400 (AST) Received: from [192.168.1.100] (or-67-76-146-141.sta.sprint-hsd.net [67.76.146.141]) (authenticated bits=0) by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id k1J3t22A010118; Sat, 18 Feb 2006 19:55:04 -0800 Message-ID: <43F7EFD0.9040404@commandprompt.com> Date: Sat, 18 Feb 2006 20:10:56 -0800 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: Chandra Sekhar Surapaneni CC: Arnau Rebassa Villalonga , pgsql-admin@postgresql.org Subject: Re: how test postgresql.conf settings? References: <0F7F9A82BB0DBB4396A9F8386D0E06120B3C15@pos-exch1.corp.positivenetworks.net> In-Reply-To: <0F7F9A82BB0DBB4396A9F8386D0E06120B3C15@pos-exch1.corp.positivenetworks.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (hosting.commandprompt.com [192.168.1.101]); Sat, 18 Feb 2006 19:55:05 -0800 (PST) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.088 required=5 tests=[AWL=0.088] X-Spam-Score: 0.088 X-Spam-Level: X-Archive-Number: 200602/231 X-Sequence-Number: 20652 Chandra Sekhar Surapaneni wrote: > If you HUP the database or reload the database the changes will take > effect. Only in a very few cases you will have to restart the > database. Can you give us more information regarding what changes you > made to the postgresql.conf? The annotated postgresql conf give you that info... www.powerpostgresql.com > > -Chandra Sekhar Surapaneni > > ------------------------------------------------------------------------ > *From:* pgsql-admin-owner@postgresql.org on behalf of Arnau Rebassa > Villalonga > *Sent:* Wed 2/15/2006 4:39 AM > *To:* pgsql-admin@postgresql.org > *Subject:* [ADMIN] how test postgresql.conf settings? > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PLphp, PLperl - http://www.commandprompt.com/