Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 25CD02E0087 for ; Tue, 27 Nov 2007 14:47:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 94870-09 for ; Tue, 27 Nov 2007 14:47:32 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id A0E082E0079 for ; Tue, 27 Nov 2007 14:47:39 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id lARIlbpv092971 for ; Tue, 27 Nov 2007 14:47:37 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id lARILbBj085935 for pgsql-performance@postgresql.org; Tue, 27 Nov 2007 14:21:37 -0400 (AST) (envelope-from news) From: cluster X-Newsgroups: pgsql.performance Subject: Re: Query only slow on first run Date: Tue, 27 Nov 2007 19:21:38 +0100 Organization: Hub.Org Networking Services Lines: 4 Message-ID: References: <20071127165543.GY11978@crankycanuck.ca> <23999.1196184368@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 2.0.0.6 (X11/20071022) In-Reply-To: <23999.1196184368@sss.pgh.pa.us> To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/323 X-Sequence-Number: 27738 >> Probably by buying much faster disk hardware. > Or buy more RAM, so that the data can stay cached. So the only problem here is lack of RAM and/or disk speed?