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
