From: Ken Hill <ken@scottshill.com>
To: Postgres Help <pgsql-sql@postgresql.org>
Subject: Modifying postgresql.org file
Date: Wed, 15 Feb 2006 08:15:46 -0800
Message-ID: <1140020147.3870.14.camel@localhost.localdomain> (raw)
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:
/etc/postgresql/7.4/main/postgresql.org
/usr/share/postgresql/7.4/postgresql.conf.sample
I believe the second one is an example/sample file (similar to how
xorg.conf comes with a sample file). Can someone point me in a direction
as to where I can learn how to modify the postgresql.org file to
increase work_mem? I have the O'Reilly book "Practical PostgreSQL" but
it doesn't seem to cover this topic. I'm fairly confident that I can
tweak the postgresql.org file; given that I was successfuly tweaking my
xorg.conf file.
Any help/guidance is very much appreciated.
-Ken
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ken@scottshill.com
Subject: Re: Modifying postgresql.org file
In-Reply-To: <1140020147.3870.14.camel@localhost.localdomain>
* 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