Help: how to speed up query after db server reboot

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

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: Help: how to speed up query after db server reboot
From: Wei Yan <weiyan1@xxxxxxxxx>
Date: Tue, 1 Sep 2009 15:01:41 -0700

Hi:

Looks like after postgres db server reboot, first query is very slow (10+mins). After the system cache built, query is pretty fast.
Now the question is how to speed up the first query slow issue?

Any pointers?

Thanks
wei

Follow-Ups:
- Re: Help: how to speed up query after db server reboot
  - From: Magnus Hagander

Prev by Date: Seeking performance advice and explanation for high I/O on 8.3
Next by Date: Slow select times on select with xpath
Previous by thread: Seeking performance advice and explanation for high I/O on 8.3
Next by thread: Re: Help: how to speed up query after db server reboot
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