Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Query only slow on first run
- From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
- To: cluster <skrald(at)amossen(dot)dk>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Query only slow on first run
- Date: Tue, 27 Nov 2007 13:55:50 -0500
In response to cluster <skrald(at)amossen(dot)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(at)collaborativefusion(dot)com Phone: 412-422-3463x4023
- 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
- Re: Query only slow on first run
- From: cluster
- Query only slow on first run
- Prev by Date: Re: Query only slow on first run
- 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
- Indexes: