Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 418632E4B01 for ; Thu, 24 Jan 2008 22:59:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 95136-02-6 for ; Thu, 24 Jan 2008 22:59:07 -0400 (AST) Received: from mail.midstorm.org (mail.midstorm.org [65.99.212.143]) by postgresql.org (Postfix) with ESMTP id 41F6F2E5386 for ; Thu, 24 Jan 2008 21:51:14 -0400 (AST) Received: from pmanson (201-24-48-227.bsace703.dsl.brasiltelecom.net.br [201.24.48.227]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.midstorm.org (Postfix) with ESMTP id BD497403BB for ; Thu, 24 Jan 2008 23:51:11 -0200 (BRST) Date: Thu, 24 Jan 2008 23:53:52 -0200 From: Fernando Ike To: pgsql-performance@postgresql.org Subject: Re: Configuration settings (shared_buffers, etc) in Linux: puzzled Message-ID: <20080124235352.7babcafe@pmanson> In-Reply-To: <4798D238.7070002@ieee.org> References: <4798D238.7070002@ieee.org> X-Mailer: Claws Mail 3.2.0 (GTK+ 2.12.5; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/225 X-Sequence-Number: 28464 Em Thu, 24 Jan 2008 13:00:24 -0500 Rick Schumeyer escreveu: > On a linux box (Linux db1 2.6.18.8-md #1 SMP Wed May 23 17:21:37 EDT > 2007 i686 GNU/Linux) > I edited postgresql.conf and changed: > > shared_buffers = 5000 work_mem = 16384 > max_stack_depth = 4096 > This configuration is possibility of the PostgreSQL 8.1. But if don't by 8.1, for example: 8.2 or 8.3, follow the talk Greg Smith. :) Best Regards, -- Fernando Ike http://www.midstorm.org/~fike/weblog