Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 37D2C475EAE for ; Fri, 17 Jan 2003 12:08:52 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 36CA4475E60 for ; Fri, 17 Jan 2003 12:08:51 -0500 (EST) Received: from [63.195.55.98] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 4.0.2) with HTTP id 2317350; Fri, 17 Jan 2003 09:08:54 -0800 From: "Josh Berkus" Subject: Re: 7.3.1 New install, large queries are slow To: Tom Lane , "Roman Fail" Cc: sszabo@megazone23.bigpanda.com, pgsql-performance@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.4.0.2 Date: Fri, 17 Jan 2003 09:08:54 -0800 Message-ID: In-Reply-To: <4981.1042783570@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/184 X-Sequence-Number: 831 Tom, > > shared_buffers = 131072 > > Yipes! Try about a tenth that much. Or less. Why? He has 4GB RAM on the machine. -Josh Berkus