Re: [PERFORM] How to enhance the chance that data is in disk cache

2005-06-13 Thread Jona
Thank you for the response Tom, I bet you get a lot of mails with "trivial" solutions (mine likely being one of them) I for one however truly appreciate you taking the time to answer them. Run the query more often? The query is dynamically constructed from user input, although the total

Re: [PERFORM] How to enhance the chance that data is in disk cache

2005-06-13 Thread Tom Lane
Jona <[EMAIL PROTECTED]> writes: > I have a query (please refer to > http://213.173.234.215:8080/get_content_plan.htm for the query as well > as query plan) that is slow when it's run the first time and fast(ish) > on all successive runs within a reasonable time period. > This leads me to suspe

[PERFORM] How to enhance the chance that data is in disk cache

2005-06-13 Thread Jona
Hi there I have a query (please refer to http://213.173.234.215:8080/get_content_plan.htm for the query as well as query plan) that is slow when it's run the first time and fast(ish) on all successive runs within a reasonable time period. That is, if the query is not run for like 30 min, execut