query slow only after reboot

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

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: query slow only after reboot
From: Wei Yan <weiyan1@xxxxxxxxx>
Date: Mon, 9 Feb 2009 17:21:31 -0800

Hi:

Our queries are extremely slow only after db server reboot, not after restart postgres db only. The difference is about 10 mins vs. 8 secs. Not acceptable. I have browsed around , set the postgres db parameters as suggested. Still the same.

Any suggestion on how to tackle the problem?

Thanks
wei

Follow-Ups:
- Re: query slow only after reboot
  - From: Kevin Grittner
- Re: query slow only after reboot
  - From: Scott Carey
- Re: query slow only after reboot
  - From: Steve Crawford

Prev by Date: Re: explanation of some configs
Next by Date: Re: query slow only after reboot
Previous by thread: explanation of some configs
Next by thread: Re: query slow only after 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