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 ; 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 ; 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 ; 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 To: ken@scottshill.com Cc: Postgres Help 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/