X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D38163A44D6 for ; Thu, 4 Nov 2004 14:02:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65901-04 for ; Thu, 4 Nov 2004 14:02:16 +0000 (GMT) Received: from smtp103.rog.mail.re2.yahoo.com (smtp103.rog.mail.re2.yahoo.com [206.190.36.81]) by svr1.postgresql.org (Postfix) with SMTP id B2A773A44BC for ; Thu, 4 Nov 2004 14:02:18 +0000 (GMT) Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@65.49.125.184 with login) by smtp103.rog.mail.re2.yahoo.com with SMTP; 4 Nov 2004 14:02:18 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 8A12E4048; Thu, 4 Nov 2004 09:02:17 -0500 (EST) Date: Thu, 4 Nov 2004 09:02:17 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: preloading indexes Message-ID: <20041104140217.GB23219@phlogiston.dyndns.org> Mail-Followup-To: pgsql-performance@postgresql.org References: <20041103193528.GB16528@phlogiston.dyndns.org> <20041103201948.HWSQ12834.fed1rmmtao10.cox.net@CYGNUS> <20041103205316.GC16528@phlogiston.dyndns.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20041103205316.GC16528@phlogiston.dyndns.org> User-Agent: Mutt/1.5.6+20040722i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/43 X-Sequence-Number: 8997 On Wed, Nov 03, 2004 at 03:53:16PM -0500, Andrew Sullivan wrote: > and may bust your query out of the cache. Also, we'd need some more Uh, the data you're querying, of course. Queries themselves aren't cached. A -- Andrew Sullivan | ajs@crankycanuck.ca I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin