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

From Dave Page
Subject Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition
Date
Msg-id AANLkTimREzfX5LCrfJ7YJ6vEP5MS0zHbLGuNvVBAKQuO@mail.gmail.com
Whole thread Raw
In response to Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
On Wed, Sep 29, 2010 at 11:37 AM, Andrus <kobruleht2@hot.ee> wrote:
>> We updated it for Win64, but it looks like the stackbuilder catalog
>> wasn't updated to allow it to be downloaded on that platform. I've
>> fixed that - it should be available within an hour or so.
>
> I just installed 9.0 x64
>
> Is it sufficient to run Program files / PostgreSql 9.0 / Application Stack
> Builder  from this installation to get it ?

Yes, in an hour or so.

> Will it set optimal configuration so that manual editing of postgresql.conf
> is not required ?

It will generate a starter configuration, that will be based on your
selected workload type and machine resources. That may be fine for
your needs, or you may need to tune it to more precisely meet the
needs of your actual workload. It doesn't claim to eliminate the need
for any future manual tuning.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition
Next
From: Georgi Ivanov
Date:
Subject: optimizing a query with sub select