Re: Postgres performance comments from a MySQL user

On 17/06/2003 10:57 Kaarel wrote:
>> can do the calculations in 10 msec.  The number that got my attention
>> was 20 minutes.  I don't see where that could come from, given the same
>
> The server was idle 20 minutes?
>
> "Just now I had the server sit for approx 20 minutes, rerunning the same
> query resulted in 3155 msec, a followup again 10.85 msec."
>

mybe after that amount of time, the kernel has marked the cached data as
stale and so re-reads it from disk?


--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+