pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Chandra Sekhar Surapaneni <chandu@positivenetworks.net>
Cc: Arnau Rebassa Villalonga <arebassa@androme.es>
Cc: pgsql-admin@postgresql.org
Subject: Re: how test postgresql.conf settings?
Date: Sat, 18 Feb 2006 20:10:56 -0800
Message-ID: <43F7EFD0.9040404@commandprompt.com> (raw)
In-Reply-To: <0F7F9A82BB0DBB4396A9F8386D0E06120B3C15@pos-exch1.corp.positivenetworks.net>
References: <0F7F9A82BB0DBB4396A9F8386D0E06120B3C15@pos-exch1.corp.positivenetworks.net>

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/




view thread (5+ messages)  latest in thread

Message-ID: <43F7EFD0.9040404@commandprompt.com>
Permalink:  ../43F7EFD0.9040404@commandprompt.com/
Also on:    postgresql.org/message-id/43F7EFD0.9040404@commandprompt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jd@commandprompt.com, chandu@positivenetworks.net, arebassa@androme.es
  Subject: Re: how test postgresql.conf settings?
  In-Reply-To: <43F7EFD0.9040404@commandprompt.com>
  References: <0F7F9A82BB0DBB4396A9F8386D0E06120B3C15@pos-exch1.corp.positivenetworks.net> <43F7EFD0.9040404@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox