Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A339F475AE6 for ; Mon, 20 Jan 2003 01:34:27 -0500 (EST) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by postgresql.org (Postfix) with ESMTP id CD0ED475AA1 for ; Mon, 20 Jan 2003 01:34:25 -0500 (EST) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h0K6YOG31276 for ; Mon, 20 Jan 2003 12:04:24 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h0K6YOU31271 for ; Mon, 20 Jan 2003 12:04:24 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Mon, 20 Jan 2003 12:04:45 +0530 MIME-Version: 1.0 Subject: Re: 7.3.1 New install, large queries are slow Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3E2BE5DD.30158.D375D9A@localhost> References: In-reply-to: <13109.1042824791@sss.pgh.pa.us> X-mailer: Pegasus Mail for Windows (v4.02) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/200 X-Sequence-Number: 847 On 17 Jan 2003 at 12:33, Tom Lane wrote: > "Josh Berkus" writes: > >>> shared_buffers = 131072 > >> > >> Yipes! Try about a tenth that much. Or less. > > > Why? He has 4GB RAM on the machine. > > I think a gig of shared buffers is overkill no matter what. > > One reason not to crank up shared_buffers "just because you can" is that > there are operations (such as CHECKPOINT) that have to scan through all > the buffers, linearly. I don't *think* any of these are in > performance-critical paths, but nonetheless you're wasting CPU. I trust Assuming that one knows what he/she is doing, would it help in such cases i.e. the linear search thing, to bump up page size to day 16K/32K? and that is also the only way to make postgresql use more than couple of gigs of RAM, isn't it? Bye Shridhar -- Arithmetic: An obscure art no longer practiced in the world's developed countries.