pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedModifying postgresql.org file
9+ messages / 6 participants
[nested] [flat]
* Modifying postgresql.org file
@ 2006-02-15 16:15 Ken Hill <ken@scottshill.com>
2006-02-15 16:20 ` Re: Modifying postgresql.org file Andrew Sullivan <ajs@crankycanuck.ca>
2006-02-15 16:24 ` Re: Modifying postgresql.org file Devrim GUNDUZ <devrim@commandprompt.com>
2006-02-15 17:09 ` Re: Modifying postgresql.org file Peter Eisentraut <peter_e@gmx.net>
0 siblings, 3 replies; 9+ messages in thread
From: Ken Hill @ 2006-02-15 16:15 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Modifying postgresql.org file
2006-02-15 16:15 Modifying postgresql.org file Ken Hill <ken@scottshill.com>
@ 2006-02-15 16:20 ` Andrew Sullivan <ajs@crankycanuck.ca>
2006-02-15 16:35 ` Re: Modifying postgresql.org file Ken Hill <ken@scottshill.com>
2 siblings, 1 reply; 9+ messages in thread
From: Andrew Sullivan @ 2006-02-15 16:20 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Modifying postgresql.org file
2006-02-15 16:15 Modifying postgresql.org file Ken Hill <ken@scottshill.com>
2006-02-15 16:20 ` Re: Modifying postgresql.org file Andrew Sullivan <ajs@crankycanuck.ca>
@ 2006-02-15 16:35 ` Ken Hill <ken@scottshill.com>
2006-02-15 16:47 ` Re: Modifying postgresql.org file Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 9+ messages in thread
From: Ken Hill @ 2006-02-15 16:35 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; +Cc: pgsql-sql
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:
> >
> > /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
>
This is how Ubuntu installed postgresql via it's synaptic package
manager.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Modifying postgresql.org file
2006-02-15 16:15 Modifying postgresql.org file Ken Hill <ken@scottshill.com>
2006-02-15 16:20 ` Re: Modifying postgresql.org file Andrew Sullivan <ajs@crankycanuck.ca>
2006-02-15 16:35 ` Re: Modifying postgresql.org file Ken Hill <ken@scottshill.com>
@ 2006-02-15 16:47 ` Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 0 replies; 9+ messages in thread
From: Andrew Sullivan @ 2006-02-15 16:47 UTC (permalink / raw)
To: Ken Hill <ken@scottshill.com>; +Cc: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-sql
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Modifying postgresql.org file
2006-02-15 16:15 Modifying postgresql.org file Ken Hill <ken@scottshill.com>
@ 2006-02-15 16:24 ` Devrim GUNDUZ <devrim@commandprompt.com>
2 siblings, 0 replies; 9+ messages in thread
From: Devrim GUNDUZ @ 2006-02-15 16:24 UTC (permalink / raw)
To: ken@scottshill.com; +Cc: pgsql-sql
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/
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Modifying postgresql.org file
2006-02-15 16:15 Modifying postgresql.org file Ken Hill <ken@scottshill.com>
@ 2006-02-15 17:09 ` Peter Eisentraut <peter_e@gmx.net>
2006-02-15 17:36 ` Re: Modifying postgresql.org file Ken Hill <ken@scottshill.com>
2 siblings, 1 reply; 9+ messages in thread
From: Peter Eisentraut @ 2006-02-15 17:09 UTC (permalink / raw)
To: pgsql-sql; ken@scottshill.com
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/
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Modifying postgresql.org file
2006-02-15 16:15 Modifying postgresql.org file Ken Hill <ken@scottshill.com>
2006-02-15 17:09 ` Re: Modifying postgresql.org file Peter Eisentraut <peter_e@gmx.net>
@ 2006-02-15 17:36 ` Ken Hill <ken@scottshill.com>
2006-02-15 17:38 ` Re: Modifying postgresql.org file Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 9+ messages in thread
From: Ken Hill @ 2006-02-15 17:36 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-sql
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"?
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Modifying postgresql.org file
2006-02-15 16:15 Modifying postgresql.org file Ken Hill <ken@scottshill.com>
2006-02-15 17:09 ` Re: Modifying postgresql.org file Peter Eisentraut <peter_e@gmx.net>
2006-02-15 17:36 ` Re: Modifying postgresql.org file Ken Hill <ken@scottshill.com>
@ 2006-02-15 17:38 ` Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 9+ messages in thread
From: Alvaro Herrera @ 2006-02-15 17:38 UTC (permalink / raw)
To: Ken Hill <ken@scottshill.com>; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-sql
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.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Modifying postgresql.org file
@ 2006-02-15 17:13 Owen Jacobson <ojacobson@osl.com>
0 siblings, 0 replies; 9+ messages in thread
From: Owen Jacobson @ 2006-02-15 17:13 UTC (permalink / raw)
To: pgsql-sql
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 the same features for sort_mem that are now described under work_mem, so adjusting sort_mem should be appropriate.
-Owen
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2006-02-15 17:38 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-15 16:15 Modifying postgresql.org file Ken Hill <ken@scottshill.com>
2006-02-15 16:20 ` Andrew Sullivan <ajs@crankycanuck.ca>
2006-02-15 16:35 ` Ken Hill <ken@scottshill.com>
2006-02-15 16:47 ` Andrew Sullivan <ajs@crankycanuck.ca>
2006-02-15 16:24 ` Devrim GUNDUZ <devrim@commandprompt.com>
2006-02-15 17:09 ` Peter Eisentraut <peter_e@gmx.net>
2006-02-15 17:36 ` Ken Hill <ken@scottshill.com>
2006-02-15 17:38 ` Alvaro Herrera <alvherre@commandprompt.com>
2006-02-15 17:13 Re: Modifying postgresql.org file Owen Jacobson <ojacobson@osl.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox