Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Dave Page" <dpage(at)pgadmin(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition
Date: 2010-10-19 11:48:30
Message-ID: 6F10A98791D04671A20D4D475A8BE0A6@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

1. Tuning wizard adds autovacuum = true line even if
autovacuum is turned on:

#autovacuum = on # Enable autovacuum subprocess? 'on'
# NOTE: This parameter is been added by EnterpriseDB's Tuning Wiard on
2010/10/18 11:19:56
autovacuum = true # Enable autovacuum subprocess? 'on'

2. Wizards adds values without units. It is difficult to figure out how much
memory changed settings really take.

How to force tuning wizard to add changes in real units if server supports
them, e.q. with KB or MB suffixes like in normal postgresql.conf file?

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2010-10-19 13:11:15 PGDay Europe 2010 Registration Open
Previous Message Stefan Schwarzer 2010-10-19 10:07:34 Problem with Crosstab - Allocating value to wrong column