Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: Re: Modifying postgresql.org file
Date: Wed, 15 Feb 2006 09:13:19 -0800
Message-ID: <144D12D7DD4EC04F99241498BB4EEDCC2206D5@nelson.osl.com>
Thread-Topic: [SQL] Modifying postgresql.org file
Thread-Index: AcYyS8mDNcyexzD3Tji5NthQrVPtLgABxBhw
From: "Owen Jacobson" <ojacobson@osl.com>
To: <pgsql-sql@postgresql.org>

Andrew Sullivan wrote:
>=20
> On Wed, Feb 15, 2006 at 08:15:46AM -0800, Ken Hill wrote:
> > It has been suggested to me to increase my work_mem to make queries
> > preform faster. I believe I do this in the 'postgresql.org' file.  I
> > seem to have two of these files:
> >=20
> > /etc/postgresql/7.4/main/postgresql.org
> > /usr/share/postgresql/7.4/postgresql.conf.sample
>=20
> Where did you get this version of Postgres?  The main config file
> should be $PGDATA/postgresql.conf.  Anything else is probably the
> result of your system's packaging having done some magic.  But in any
> case, unless I'm misremembering, the work_mem setting isn't in 7.4.

In 8.0, the setting sort_mem was renamed to work_mem (sayeth the 8.0.0 =
release notes).  The 7.4 documentation describes the same features for =
sort_mem that are now described under work_mem, so adjusting sort_mem =
should be appropriate.

-Owen