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

Поиск
Список
Период
Сортировка
От zxo102 ouyang
Тема How to speed up the first-time-searching in pgsql?
Дата
Msg-id 73ccced30905261657g736af84bybf6c52f3f0643694@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Need beginning and ending date value for a particular week in the year
Следующее
От: John R Pierce
Дата:
Сообщение: Re: How to speed up the first-time-searching in pgsql?