Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8B380475CE5 for ; Sat, 18 Jan 2003 11:26:21 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 7EF2D475E26 for ; Sat, 18 Jan 2003 11:24:21 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18Zvli-0006Hg-00 for ; Sat, 18 Jan 2003 11:24:26 -0500 Date: Sat, 18 Jan 2003 11:24:26 -0500 From: Andrew Sullivan To: "pgsql-performance@postgresql.org" Subject: Re: 7.3.1 New install, large queries are slow Message-ID: <20030118112426.A23790@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , "pgsql-performance@postgresql.org" References: <21623.1042865371@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <21623.1042865371@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Fri, Jan 17, 2003 at 11:49:31PM -0500 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/198 X-Sequence-Number: 845 On Fri, Jan 17, 2003 at 11:49:31PM -0500, Tom Lane wrote: > Jeff writes: > > Informix, oracle, etc all do raw device access bypassing the kernels > > buffering, etc. So they need heaping gobules of memory to do the same > > thing the kernel does.. > > D'oh, I believe Jeff's put his finger on it. You need lotsa RAM if you > are trying to bypass the OS. But Postgres would like to work with the > OS, not bypass it. One of the interesting things I have been playing with on Solaris recently is the various no-buffer settings you can give to the kernel for filesystems. The idea is that you don't have the kernel do the buffering, and you set your database's shared memory setting _reeeeal_ high. As nearly as I can tell, there is again no benefit with PostgreSQL. I'd also be amazed if this approach is a win for other systems. But a lot of DBAs seem to believe that they know better than their computers which tables are "really" accessed frequently. I think they must be smarter than I am: I'd rather trust a system that was designed to track these things and change the tuning on the fly, myself. (To be fair, there are some cases where you have an infrequently-accessed table which nevertheless is required to be fast for some reason or other, so you might want to force it to stay in memory.) A ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110