Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition - Mailing list pgsql-general

From Craig Ringer
Subject Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition
Date
Msg-id 4CA5E4DC.2030509@postnewspapers.com.au
Whole thread Raw
In response to Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
On 1/10/2010 9:24 PM, Andrus wrote:

> How to configure remote servers where only port 5432 is open ?

You can't. You need to be able to modify postgresql.conf .

> Why pgAdmin postgresql.conf editor does not contain automatic
> configurator ?

Because nobody has written one for PgAdmin. The EnterpriseDB
configuration assistant is a commercial product that EnterpriseDB are
letting people use for free. Nobody's stepped up to do the incredible
amount of testing and benchmarking required to create a configuraton
assistant for inclusion in PgAdmin.

Such tools are a guide at best; they won't just magically configure your
system perfectly. All databases need a degree of tuning to achieve
optimal performance, and PostgreSQL is no exception.

--
Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition
Next
From: Raymond O'Donnell
Date:
Subject: Re: Slony-I cluster creation Help.