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 BA60C3A4675 for ; Wed, 3 Nov 2004 20:53:25 +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 89710-04 for ; Wed, 3 Nov 2004 20:53:18 +0000 (GMT) Received: from smtp101.rog.mail.re2.yahoo.com (smtp101.rog.mail.re2.yahoo.com [206.190.36.79]) by svr1.postgresql.org (Postfix) with SMTP id 111863A465B for ; Wed, 3 Nov 2004 20:53:19 +0000 (GMT) Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@65.49.125.184 with login) by smtp101.rog.mail.re2.yahoo.com with SMTP; 3 Nov 2004 20:53:18 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 7ACEC404C; Wed, 3 Nov 2004 15:53:16 -0500 (EST) Date: Wed, 3 Nov 2004 15:53:16 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: preloading indexes Message-ID: <20041103205316.GC16528@phlogiston.dyndns.org> Mail-Followup-To: pgsql-performance@postgresql.org References: <20041103193528.GB16528@phlogiston.dyndns.org> <20041103201948.HWSQ12834.fed1rmmtao10.cox.net@CYGNUS> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20041103201948.HWSQ12834.fed1rmmtao10.cox.net@CYGNUS> 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/28 X-Sequence-Number: 8982 On Wed, Nov 03, 2004 at 01:19:43PM -0700, stuff@opensourceonline.com wrote: > The caching appears to disappear overnight. The environment is not in > production yet so I'm the only one on it. Are you vacuuming at night? It grovels through the entire database, and may bust your query out of the cache. Also, we'd need some more info about how you've tuned this thing. Maybe check out the archives first for some tuning pointers to help you. A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland