How to speed up the first-time-searching in pgsql?

From: zxo102 ouyang <zxo102(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to speed up the first-time-searching in pgsql?
Date: 2009-05-26 23:57:38
Message-ID: 73ccced30905261657g736af84bybf6c52f3f0643694@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
I have a table which has more than 10millions records in pgsql which is
running on window 2003. During night, nobody search the database.
In morning, when people start to the application, it will take more than 30
seconds to get database back. After several times of same searching, the
results can be returned in 8 seconds.
Is this related to some kinds of process priority setting in window
2003? If so, how do I set the pgsql processes in highest priority?

Thanks in advance.

ouyang

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-05-27 00:20:13 Re: How to speed up the first-time-searching in pgsql?
Previous Message Alvaro Herrera 2009-05-26 22:19:28 Re: Need beginning and ending date value for a particular week in the year