Hi:
Looks like after postgres db server reboot, first query is very slow
(10+mins). After the system cache built, query is pretty fast.
Now the question is how to speed up the first query slow issue?
Any pointers?
Thanks
wei
Hi:
Our queries are extremely slow only after db server reboot, not after
restart postgres db only. The difference is about 10 mins vs. 8 secs. Not
acceptable. I have browsed around , set the postgres db parameters as
suggested. Still the same.
Any suggestion on how to tackle the problem?
Thanks
