PostgreSQL SQL - Modifying postgresql.org file

Author

Modifying postgresql.org file

Ken Hill

2006-02-15, 11:24 am

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

Andrew Sullivan

2006-02-15, 11:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Devrim GUNDUZ

2006-02-15, 11:24 am

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/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Ken Hill

2006-02-15, 11:24 am

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:
>
> 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
>

This is how Ubuntu installed postgresql via it's synaptic package
manager.

Andrew Sullivan

2006-02-15, 11:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Peter Eisentraut

2006-02-15, 11:24 am

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 posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Owen Jacobson

2006-02-15, 11:24 am

Andrew Sullivan wrote:
>
> On Wed, Feb 15, 2006 at 08:15:46AM -0800, Ken Hill wrote:
>
> 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 the same features for sort_mem that are now described under work_mem, so adjusting sort_mem should be appropriate.

-Owen

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Ken Hill

2006-02-15, 1:24 pm

On Wed, 2006-02-15 at 18:09 +0100, Peter Eisentraut wrote:

> Ken Hill wrote:
>
> RTFM
>

I apologize for my lack of knowledge, but what is "RTFM"?

Alvaro Herrera

2006-02-15, 1:24 pm

Ken Hill wrote:
> On Wed, 2006-02-15 at 18:09 +0100, Peter Eisentraut wrote:
>
>
> 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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links