Thread: Modifying postgresql.org file
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
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
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/
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.
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
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/
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
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"?
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.