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 A88AD9DC9D3 for ; Wed, 22 Feb 2006 05:03:56 -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 63162-01 for ; Wed, 22 Feb 2006 05:03:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from fafnir.androme.com (fafnir.androme.com [62.58.96.158]) by postgresql.org (Postfix) with ESMTP id 6C2149DC9C5 for ; Wed, 22 Feb 2006 05:03:53 -0400 (AST) Received: by fafnir.androme.com (Postfix, from userid 1003) id AD4AAB9173D; Wed, 22 Feb 2006 10:03:54 +0100 (CET) Message-ID: <43FC28F8.2020208@andromeiberica.com> Date: Wed, 22 Feb 2006 10:03:52 +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: Chandra Sekhar Surapaneni CC: 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-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.124 required=5 tests=[AWL=0.124] X-Spam-Score: 0.124 X-Spam-Level: X-Archive-Number: 200602/251 X-Sequence-Number: 20672 Sorry for answering so late, but I didn't notice your answer... 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? I was tweaking the Resource usage part shared_buffers, work_mem, ... The problem is I was restarting the database with: /etc/init.d/postgresql restart The problem is that the result I was getting after the restart were much better than if I reboot the machine. So I don't know why of that big difference, if due to postgresql or due the kernel cache or where... > > -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? -- Arnau