From ken@scottshill.com Wed Feb  15 16:15:50 2006
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 5288E9DCA4D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 12:15:50 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 55438-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 12:15:48 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [216.148.227.151])
	by postgresql.org (Postfix) with ESMTP id 0B0389DCA0F
	for <pgsql-sql@postgresql.org>; Wed, 15 Feb 2006 12:15:47 -0400 (AST)
Received: from [10.0.1.5] (c-24-20-199-254.hsd1.or.comcast.net[24.20.199.254])
	by comcast.net (rwcrmhc11) with SMTP
	id <20060215161546m1100pp3eoe>; Wed, 15 Feb 2006 16:15:46 +0000
Subject: Modifying postgresql.org file
From: Ken Hill <ken@scottshill.com>
Reply-To: ken@scottshill.com
To: Postgres Help <pgsql-sql@postgresql.org>
Content-Type: multipart/alternative; boundary="=-9dTmg0cHJvv0MoxFO3bi"
Organization: Scotts Hill Associates, Inc.
Date: Wed, 15 Feb 2006 08:15:46 -0800
Message-Id: <1140020147.3870.14.camel@localhost.localdomain>
Mime-Version: 1.0
X-Mailer: Evolution 2.4.1 
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.089 required=5 tests=[AWL=0.088,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.089
X-Spam-Level: 
X-Archive-Number: 200602/165
X-Sequence-Number: 24175


--=-9dTmg0cHJvv0MoxFO3bi
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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

--=-9dTmg0cHJvv0MoxFO3bi
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.8.1">
</HEAD>
<BODY>
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.&nbsp; 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 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 &quot;Practical PostgreSQL&quot; 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. <BR>
<BR>
Any help/guidance is very much appreciated.<BR>
<BR>
-Ken
</BODY>
</HTML>

--=-9dTmg0cHJvv0MoxFO3bi--




From ajs@crankycanuck.ca Wed Feb  15 16:20:38 2006
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id E17809DC897
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 12:20:38 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 55290-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 12:20:36 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from r1.mycybernet.net (r1.mycybernet.net [209.5.206.8])
	by postgresql.org (Postfix) with ESMTP id 6E5D49DC803
	for <pgsql-sql@postgresql.org>; Wed, 15 Feb 2006 12:20:36 -0400 (AST)
Received: from 227-54-222-209.mycybernet.net ([209.222.54.227]:33912
	helo=phlogiston.dydns.org)
	by r1.mycybernet.net with esmtp (Exim 4.50 (FreeBSD))
	id 1F9POL-000E4T-5j
	for pgsql-sql@postgresql.org; Wed, 15 Feb 2006 11:20:33 -0500
Received: by phlogiston.dydns.org (Postfix, from userid 1000)
	id C6D463FAF; Wed, 15 Feb 2006 11:20:31 -0500 (EST)
Date: Wed, 15 Feb 2006 11:20:31 -0500
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Modifying postgresql.org file
Message-ID: <20060215162031.GB6562@phlogiston.dyndns.org>
References: <1140020147.3870.14.camel@localhost.localdomain>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1140020147.3870.14.camel@localhost.localdomain>
User-Agent: Mutt/1.5.9i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.096 required=5 tests=[AWL=0.096]
X-Spam-Score: 0.096
X-Spam-Level: 
X-Archive-Number: 200602/166
X-Sequence-Number: 24176

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



From devrim@commandprompt.com Wed Feb  15 16:21:54 2006
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 459349DCB11
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 12:21:54 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 56246-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 12:21:52 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.kivi.com.tr (mail.kivi.com.tr [213.143.254.37])
	by postgresql.org (Postfix) with ESMTP id 4A73C9DCAA8
	for <pgsql-sql@postgresql.org>; Wed, 15 Feb 2006 12:21:50 -0400 (AST)
Received: from pgbuildfarm.gunduz.org (ankara [212.174.30.202])
	by mail.kivi.com.tr (Postfix) with ESMTP id 32DBA80019;
	Wed, 15 Feb 2006 18:21:29 +0200 (EET)
Subject: Re: Modifying postgresql.org file
From: Devrim GUNDUZ <devrim@commandprompt.com>
To: ken@scottshill.com
Cc: Postgres Help <pgsql-sql@postgresql.org>
In-Reply-To: <1140020147.3870.14.camel@localhost.localdomain>
References: <1140020147.3870.14.camel@localhost.localdomain>
Content-Type: text/plain
Organization: Command Prompt Inc.
Date: Wed, 15 Feb 2006 18:24:24 +0200
Message-Id: <1140020664.23705.19.camel@pgbuildfarm.gunduz.org>
Mime-Version: 1.0
X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) 
Content-Transfer-Encoding: 7bit
X-Kivi-MailScanner-Information: Please contact the ISP for more information
X-Kivi-MailScanner: Found to be clean
X-Kivi-MailScanner-SpamCheck: not spam, SpamAssassin (score=1.792,
	required 6, autolearn=disabled, RCVD_IN_NJABL_DUL 1.66,
	RCVD_IN_SORBS_DUL 0.14)
X-Kivi-MailScanner-SpamScore: 1
X-Kivi-MailScanner-From: devrim@commandprompt.com
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.057 required=5 tests=[AWL=0.057]
X-Spam-Score: 0.057
X-Spam-Level: 
X-Archive-Number: 200602/167
X-Sequence-Number: 24177

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/




From ken@scottshill.com Wed Feb  15 16:35:36 2006
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 51DB99DCC00
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 12:35:36 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 59353-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 12:35:33 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from rwcrmhc14.comcast.net (rwcrmhc14.comcast.net [216.148.227.154])
	by postgresql.org (Postfix) with ESMTP id 8C3419DCBDF
	for <pgsql-sql@postgresql.org>; Wed, 15 Feb 2006 12:35:32 -0400 (AST)
Received: from [10.0.1.5] (c-24-20-199-254.hsd1.or.comcast.net[24.20.199.254])
	by comcast.net (rwcrmhc14) with SMTP
	id <20060215163530m1400qlfhve>; Wed, 15 Feb 2006 16:35:31 +0000
Subject: Re: Modifying postgresql.org file
From: Ken Hill <ken@scottshill.com>
Reply-To: ken@scottshill.com
To: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20060215162031.GB6562@phlogiston.dyndns.org>
References: <1140020147.3870.14.camel@localhost.localdomain>
	<20060215162031.GB6562@phlogiston.dyndns.org>
Content-Type: multipart/alternative; boundary="=-OjQAXZd+wQA3aAoKWP/i"
Organization: Scotts Hill Associates, Inc.
Date: Wed, 15 Feb 2006 08:35:31 -0800
Message-Id: <1140021331.3870.16.camel@localhost.localdomain>
Mime-Version: 1.0
X-Mailer: Evolution 2.4.1 
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.091 required=5 tests=[AWL=0.090,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.091
X-Spam-Level: 
X-Archive-Number: 200602/168
X-Sequence-Number: 24178


--=-OjQAXZd+wQA3aAoKWP/i
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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.

--=-OjQAXZd+wQA3aAoKWP/i
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.8.1">
</HEAD>
<BODY>
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">&gt; It has been suggested to me to increase my work_mem to make queries</FONT>
<FONT COLOR="#000000">&gt; preform faster. I believe I do this in the 'postgresql.org' file.  I</FONT>
<FONT COLOR="#000000">&gt; seem to have two of these files:</FONT>
<FONT COLOR="#000000">&gt; </FONT>
<FONT COLOR="#000000">&gt; /etc/postgresql/7.4/main/postgresql.org</FONT>
<FONT COLOR="#000000">&gt; /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.
</BODY>
</HTML>

--=-OjQAXZd+wQA3aAoKWP/i--




From ajs@crankycanuck.ca Wed Feb  15 16:47:35 2006
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id EF7219DCAD7
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 12:47:35 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 60159-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 12:47:34 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from r1.mycybernet.net (r1.mycybernet.net [209.5.206.8])
	by postgresql.org (Postfix) with ESMTP id C93CD9DCAB8
	for <pgsql-sql@postgresql.org>; Wed, 15 Feb 2006 12:47:33 -0400 (AST)
Received: from 227-54-222-209.mycybernet.net ([209.222.54.227]:33913
	helo=phlogiston.dydns.org)
	by r1.mycybernet.net with esmtp (Exim 4.50 (FreeBSD))
	id 1F9PoK-000G3Z-8P; Wed, 15 Feb 2006 11:47:24 -0500
Received: by phlogiston.dydns.org (Postfix, from userid 1000)
	id CBC2D3FAF; Wed, 15 Feb 2006 11:47:19 -0500 (EST)
Date: Wed, 15 Feb 2006 11:47:19 -0500
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: Ken Hill <ken@scottshill.com>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>, pgsql-sql@postgresql.org
Subject: Re: Modifying postgresql.org file
Message-ID: <20060215164719.GC6562@phlogiston.dyndns.org>
References: <1140020147.3870.14.camel@localhost.localdomain>
	<20060215162031.GB6562@phlogiston.dyndns.org>
	<1140021331.3870.16.camel@localhost.localdomain>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1140021331.3870.16.camel@localhost.localdomain>
User-Agent: Mutt/1.5.9i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.097 required=5 tests=[AWL=0.097]
X-Spam-Score: 0.097
X-Spam-Level: 
X-Archive-Number: 200602/169
X-Sequence-Number: 24179

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



From peter_e@gmx.net Wed Feb  15 17:09:15 2006
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 7DB959DC997
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 13:09:15 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 63629-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 13:09:14 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from mail.gmx.net (mail.gmx.de [213.165.64.21])
	by postgresql.org (Postfix) with SMTP id 1DAAD9DC803
	for <pgsql-sql@postgresql.org>; Wed, 15 Feb 2006 13:09:12 -0400 (AST)
Received: (qmail invoked by alias); 15 Feb 2006 17:09:12 -0000
Received: from dslb-084-063-040-180.pools.arcor-ip.net (EHLO colt.pezone.net)
	[84.63.40.180]
	by mail.gmx.net (mp038) with SMTP; 15 Feb 2006 18:09:12 +0100
X-Authenticated: #495269
From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-sql@postgresql.org,
 ken@scottshill.com
Subject: Re: Modifying postgresql.org file
Date: Wed, 15 Feb 2006 18:09:10 +0100
User-Agent: KMail/1.8.3
References: <1140020147.3870.14.camel@localhost.localdomain>
In-Reply-To: <1140020147.3870.14.camel@localhost.localdomain>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200602151809.10813.peter_e@gmx.net>
X-Y-GMX-Trusted: 0
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.121 required=5 tests=[AWL=0.121]
X-Spam-Score: 0.121
X-Spam-Level: 
X-Archive-Number: 200602/170
X-Sequence-Number: 24180

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/



From ojacobson@osl.com Wed Feb  15 17:13:16 2006
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 157D69DCBC7
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 13:13:16 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 68121-02-2
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 13:13:14 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from nelson.osl.com (216-21-133-120.ip.van.radiant.net
	[216.21.133.120])
	by postgresql.org (Postfix) with ESMTP id BEC279DCB98
	for <pgsql-sql@postgresql.org>; Wed, 15 Feb 2006 13:13:12 -0400 (AST)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Subject: Re: Modifying postgresql.org file
Date: Wed, 15 Feb 2006 09:13:19 -0800
Message-ID: <144D12D7DD4EC04F99241498BB4EEDCC2206D5@nelson.osl.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [SQL] Modifying postgresql.org file
Thread-Index: AcYyS8mDNcyexzD3Tji5NthQrVPtLgABxBhw
From: "Owen Jacobson" <ojacobson@osl.com>
To: <pgsql-sql@postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.109 required=5 tests=[AWL=0.109]
X-Spam-Score: 0.109
X-Spam-Level: 
X-Archive-Number: 200602/171
X-Sequence-Number: 24181

Andrew Sullivan wrote:
>=20
> 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:
> >=20
> > /etc/postgresql/7.4/main/postgresql.org
> > /usr/share/postgresql/7.4/postgresql.conf.sample
>=20
> 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



From ken@scottshill.com Wed Feb  15 17:36:24 2006
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id D9B1B9DC835
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 13:36:24 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 70229-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 13:36:23 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from rwcrmhc13.comcast.net (rwcrmhc13.comcast.net [204.127.192.83])
	by postgresql.org (Postfix) with ESMTP id 61E269DC821
	for <pgsql-sql@postgresql.org>; Wed, 15 Feb 2006 13:36:22 -0400 (AST)
Received: from [10.0.1.5] (c-24-20-199-254.hsd1.or.comcast.net[24.20.199.254])
	by comcast.net (rwcrmhc13) with SMTP
	id <20060215173622m1300fkjqve>; Wed, 15 Feb 2006 17:36:22 +0000
Subject: Re: Modifying postgresql.org file
From: Ken Hill <ken@scottshill.com>
Reply-To: ken@scottshill.com
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <200602151809.10813.peter_e@gmx.net>
References: <1140020147.3870.14.camel@localhost.localdomain>
	<200602151809.10813.peter_e@gmx.net>
Content-Type: multipart/alternative; boundary="=-AWja+Sls92FVHHOgtxiL"
Organization: Scotts Hill Associates, Inc.
Date: Wed, 15 Feb 2006 09:36:23 -0800
Message-Id: <1140024983.3870.20.camel@localhost.localdomain>
Mime-Version: 1.0
X-Mailer: Evolution 2.4.1 
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.092 required=5 tests=[AWL=0.091,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.092
X-Spam-Level: 
X-Archive-Number: 200602/172
X-Sequence-Number: 24182


--=-AWja+Sls92FVHHOgtxiL
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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"?

--=-AWja+Sls92FVHHOgtxiL
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.8.1">
</HEAD>
<BODY>
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">&gt; Can someone point me in a</FONT>
<FONT COLOR="#000000">&gt; direction as to where I can learn how to modify the postgresql.org</FONT>
<FONT COLOR="#000000">&gt; file to increase work_mem?</FONT>

<FONT COLOR="#000000">RTFM</FONT>

</PRE>
</BLOCKQUOTE>
I apologize for my lack of knowledge, but what is &quot;RTFM&quot;?
</BODY>
</HTML>

--=-AWja+Sls92FVHHOgtxiL--




From alvherre@commandprompt.com Wed Feb  15 17:38:58 2006
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id D8AB69DCAB8
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 13:38:58 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 73028-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Feb 2006 13:38:54 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mx2.surnet.cl (mx2.surnet.cl [216.155.73.181])
	by postgresql.org (Postfix) with ESMTP id 566009DC835
	for <pgsql-sql@postgresql.org>; Wed, 15 Feb 2006 13:38:53 -0400 (AST)
Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165])
	by mx2.surnet.cl with ESMTP; 15 Feb 2006 14:56:55 -0300
X-IronPort-AV: i="3.99,385,1131332400";
	d="scan'208"; a="26080504:sNHT19368764"
Received: from alvh.no-ip.org (200.126.100.198) by cluster.surnet.cl (7.0.043)
	(authenticated as alvherre@surnet.cl)
	id 43A978FD007250E6; Wed, 15 Feb 2006 14:38:52 -0300
Received: by alvh.no-ip.org (Postfix, from userid 1000)
	id 9EA5FC2DC59; Wed, 15 Feb 2006 14:38:52 -0300 (CLST)
Date: Wed, 15 Feb 2006 14:38:52 -0300
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Ken Hill <ken@scottshill.com>
Cc: Peter Eisentraut <peter_e@gmx.net>, pgsql-sql@postgresql.org
Subject: Re: Modifying postgresql.org file
Message-ID: <20060215173852.GD7270@surnet.cl>
Mail-Followup-To: Ken Hill <ken@scottshill.com>,
	Peter Eisentraut <peter_e@gmx.net>, pgsql-sql@postgresql.org
References: <1140020147.3870.14.camel@localhost.localdomain>
	<200602151809.10813.peter_e@gmx.net>
	<1140024983.3870.20.camel@localhost.localdomain>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1140024983.3870.20.camel@localhost.localdomain>
User-Agent: Mutt/1.5.11
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=1.993 required=5 tests=[AWL=0.074,
	DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44]
X-Spam-Score: 1.993
X-Spam-Level: *
X-Archive-Number: 200602/173
X-Sequence-Number: 24183

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.