Postgres Pro
Downloads
Home   >   mailing lists

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

From zxo102 ouyang
Subject How to speed up the first-time-searching in pgsql?
Date
Msg-id 73ccced30905261657g736af84bybf6c52f3f0643694@mail.gmail.com
Whole thread Raw
Responses Re: How to speed up the first-time-searching in pgsql?  (John R Pierce <pierce@hogranch.com>)
Re: How to speed up the first-time-searching in pgsql?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Need beginning and ending date value for a particular week in the year
Next
From: John R Pierce
Date:
Subject: Re: How to speed up the first-time-searching in pgsql?