[SQL] Modifying postgresql.org file

2006-02-15 Thread Ken Hill
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

Re: [SQL] Modifying postgresql.org file

2006-02-15 Thread Andrew Sullivan
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

Re: [SQL] Modifying postgresql.org file

2006-02-15 Thread Devrim GUNDUZ
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

Re: [SQL] Modifying postgresql.org file

2006-02-15 Thread Ken Hill
On Wed, 2006-02-15 at 11:20 -0500, 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:

Re: [SQL] Modifying postgresql.org file

2006-02-15 Thread Andrew Sullivan
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

Re: [SQL] Modifying postgresql.org file

2006-02-15 Thread Peter Eisentraut
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/ ---(end of broadcast)--- TIP 1: if

Re: [SQL] Modifying postgresql.org file

2006-02-15 Thread Owen Jacobson
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:

Re: [SQL] Modifying postgresql.org file

2006-02-15 Thread Ken Hill
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?

Re: [SQL] Modifying postgresql.org file

2006-02-15 Thread Alvaro Herrera
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?