Re: Query only slow on first run

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

 



In response to cluster <skrald@xxxxxxxxxx>:

> >> 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@xxxxxxxxxxxxxxxxxxxxxxx
Phone: 412-422-3463x4023

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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

  Powered by Linux