zxo102 ouyang wrote:
Hi there, Thanks for your suggestions. I do have an application running on the machine all the time. In fact, the application keeps writing real-time monitoring data into the database. Based on my understanding of your messages, I can't do anything to speed up the first-time-searching. Probably I can give a waiting process bar to the users and let them wait for the results.
No, I think you missed the detail on some of the answers. There are limitations (as discussed in the answers), but the simple suggestion in the first answer will probably help a lot.
Set up a scheduled task to run a big search of the database an hour before people start work. This can be as simple as a .BAT file running "SELECT * FROM big_table" triggered by Windows' Task Scheduler.
-- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
