Re: Postgres performance comments from a MySQL user - Mailing list pgsql-general

From Paul Thomas
Subject Re: Postgres performance comments from a MySQL user
Date
Msg-id 20030617114728.A15871@bacon
Whole thread Raw
In response to Re: Postgres performance comments from a MySQL user  (Kaarel <kaarel@future.ee>)
List pgsql-general
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   |
+------------------------------+---------------------------------------------+

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Damn triggers and NEW
Next
From: Jan Wieck
Date:
Subject: Re: full featured alter table?