From: Bill Moran <wmoran@collaborativefusion.com>
To: cluster <skrald@amossen.dk>
Cc: pgsql-performance@postgresql.org
Subject: Re: Query only slow on first run
Date: Tue, 27 Nov 2007 13:55:50 -0500
Message-ID: <20071127135550.956f0f9e.wmoran@collaborativefusion.com> (raw)
In-Reply-To: <fihn7h$2jrn$1@news.hub.org>
References: <fihgt1$1mmh$1@news.hub.org>
<20071127165543.GY11978@crankycanuck.ca>
<23999.1196184368@sss.pgh.pa.us>
<fihn7h$2jrn$1@news.hub.org>
In response to cluster <skrald@amossen.dk>:
> >> 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?
Not automatically, but the chances that more RAM and/or faster disks will
improve this situation are probably 90% or better.
Other things that could cause this problem are poor schema design, and
unreasonable expectations.
--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/
wmoran@collaborativefusion.com
Phone: 412-422-3463x4023
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wmoran@collaborativefusion.com, skrald@amossen.dk
Subject: Re: Query only slow on first run
In-Reply-To: <20071127135550.956f0f9e.wmoran@collaborativefusion.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox