Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D8135475BC3 for ; Fri, 17 Jan 2003 01:06:17 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 28AC647592C for ; Fri, 17 Jan 2003 01:06:17 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0H66A5u004982; Fri, 17 Jan 2003 01:06:10 -0500 (EST) To: "Roman Fail" Cc: "Josh Berkus" , sszabo@megazone23.bigpanda.com, pgsql-performance@postgresql.org Subject: Re: 7.3.1 New install, large queries are slow In-reply-to: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C09@pos_pdc.posportal.com> References: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C09@pos_pdc.posportal.com> Comments: In-reply-to "Roman Fail" message dated "Thu, 16 Jan 2003 21:54:39 -0800" Date: Fri, 17 Jan 2003 01:06:10 -0500 Message-ID: <4981.1042783570@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/172 X-Sequence-Number: 819 "Roman Fail" writes: > shared_buffers = 131072 Yipes! Try about a tenth that much. Or less. regards, tom lane