Re: Query only slow on first run

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: Query only slow on first run
From: cluster <skrald@xxxxxxxxxx>
Date: Tue, 27 Nov 2007 19:21:38 +0100
In-reply-to: <23999.1196184368@xxxxxxxxxxxxx>
Organization: Hub.Org Networking Services
References: <fihgt1$1mmh$1@xxxxxxxxxxxx> <20071127165543.GY11978@xxxxxxxxxxxxxxx> <23999.1196184368@xxxxxxxxxxxxx>
User-agent: Thunderbird 2.0.0.6 (X11/20071022)

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?

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Follow-Ups:
- Re: Query only slow on first run
  - From: Dave Dutcher
- Re: Query only slow on first run
  - From: Bill Moran

References:
- Query only slow on first run
  - From: cluster
- Re: Query only slow on first run
  - From: Andrew Sullivan
- Re: Query only slow on first run
  - From: Tom Lane

Prev by Date: Re: GiST indexing tuples
Next by Date: Re: Query only slow on first run
Previous by thread: Re: Query only slow on first run
Next by thread: Re: Query only slow on first run
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux