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.
