Thread: Modifying postgresql.org file

Modifying postgresql.org file

From
Ken Hill
Date:
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:<br /><br /> /etc/postgresql/7.4/main/postgresql.org<br />
/usr/share/postgresql/7.4/postgresql.conf.sample<br/><br /> I believe the second one is an example/sample file (similar
tohow xorg.conf comes with a sample file). Can someone point me in a direction as to where I can learn how to modify
thepostgresql.org file to increase work_mem? I have the O'Reilly book "Practical PostgreSQL" but it doesn't seem to
coverthis topic. I'm fairly confident that I can tweak the postgresql.org file; given that I was successfuly tweaking
myxorg.conf file. <br /><br /> Any help/guidance is very much appreciated.<br /><br /> -Ken  

Re: Modifying postgresql.org file

From
Andrew Sullivan
Date:
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:
> 
> /etc/postgresql/7.4/main/postgresql.org
> /usr/share/postgresql/7.4/postgresql.conf.sample

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.

You can check the docs on postgresql.org.  There's a whole section on
the configuration variables, and manuals are available for several
releases back.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Information security isn't a technological problem.  It's an economics
problem.    --Bruce Schneier


Re: Modifying postgresql.org file

From
Devrim GUNDUZ
Date:
Hi,

On Wed, 2006-02-15 at 08:15 -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:
> 
> /etc/postgresql/7.4/main/postgresql.org
> /usr/share/postgresql/7.4/postgresql.conf.sample

It must be postgresql.conf, not postgresql.

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/



Re: Modifying postgresql.org file

From
Ken Hill
Date:
 On Wed, 2006-02-15 at 11:20 -0500, Andrew Sullivan wrote: <blockquote type="CITE"><pre>
<font color="#000000">On Wed, Feb 15, 2006 at 08:15:46AM -0800, Ken Hill wrote:</font>
<font color="#000000">> It has been suggested to me to increase my work_mem to make queries</font>
<font color="#000000">> preform faster. I believe I do this in the 'postgresql.org' file.  I</font>
<font color="#000000">> seem to have two of these files:</font>
<font color="#000000">> </font>
<font color="#000000">> /etc/postgresql/7.4/main/postgresql.org</font>
<font color="#000000">> /usr/share/postgresql/7.4/postgresql.conf.sample</font>

<font color="#000000">Where did you get this version of Postgres?  The main config file</font>
<font color="#000000">should be $PGDATA/postgresql.conf.  Anything else is probably the</font>
<font color="#000000">result of your system's packaging having done some magic.  But in any</font>
<font color="#000000">case, unless I'm misremembering, the work_mem setting isn't in 7.4.</font>

<font color="#000000">You can check the docs on postgresql.org.  There's a whole section on</font>
<font color="#000000">the configuration variables, and manuals are available for several</font>
<font color="#000000">releases back.</font>

<font color="#000000">A</font>

</pre></blockquote> This is how Ubuntu installed postgresql via it's synaptic package manager.

Re: Modifying postgresql.org file

From
Andrew Sullivan
Date:
On Wed, Feb 15, 2006 at 08:35:31AM -0800, Ken Hill wrote:
> 
> This is how Ubuntu installed postgresql via it's synaptic package
> manager.

Ok, then I suspect you need to consult the Ubuntu docs about what
they did differently.  If my understanding of Ubuntu is correct, that
should be under /usr/share/doc/.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.    --George Orwell


Re: Modifying postgresql.org file

From
Peter Eisentraut
Date:
Ken Hill wrote:
> Can someone point me in a
> direction as to where I can learn how to modify the postgresql.org
> file to increase work_mem?

RTFM

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


Re: Modifying postgresql.org file

From
"Owen Jacobson"
Date:
Andrew Sullivan wrote:
>
> 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:
> >
> > /etc/postgresql/7.4/main/postgresql.org
> > /usr/share/postgresql/7.4/postgresql.conf.sample
>
> 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
thesame features for sort_mem that are now described under work_mem, so adjusting sort_mem should be appropriate. 

-Owen


Re: Modifying postgresql.org file

From
Ken Hill
Date:
 On Wed, 2006-02-15 at 18:09 +0100, Peter Eisentraut wrote: <blockquote type="CITE"><pre>
<font color="#000000">Ken Hill wrote:</font>
<font color="#000000">> Can someone point me in a</font>
<font color="#000000">> direction as to where I can learn how to modify the postgresql.org</font>
<font color="#000000">> file to increase work_mem?</font>

<font color="#000000">RTFM</font>

</pre></blockquote> I apologize for my lack of knowledge, but what is "RTFM"?

Re: Modifying postgresql.org file

From
Alvaro Herrera
Date:
Ken Hill wrote:
> On Wed, 2006-02-15 at 18:09 +0100, Peter Eisentraut wrote:
> 
> > Ken Hill wrote:
> > > Can someone point me in a
> > > direction as to where I can learn how to modify the postgresql.org
> > > file to increase work_mem?
> > 
> > RTFM
> 
> I apologize for my lack of knowledge, but what is "RTFM"?

"Read The Fine Manual"

If you hear that the F means something else, don't listen!! ;-)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.