From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
---|---|
To: | Ernest E Vogelsinger <ernest(at)vogelsinger(dot)at> |
Cc: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Justin Clift <justin(at)postgresql(dot)org>, Joseph Shraibman <jks(at)selectacast(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgres performance comments from a MySQL user |
Date: | 2003-06-14 23:02:48 |
Message-ID: | 3EEBA998.9060307@paradise.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Interesting - I've noticed this too
I did wonder if its the Linux buffer cache manager being over
aggressive about flushing...?
regards
Mark
Ernest E Vogelsinger wrote:
>I have a query that runs for 17secs for the first time. Now, when executed
>a second time, it consumes 270 msec. From the third execution it's running
>with 29 msec.
>
>However this only holds for the open connection. When connecting anew, it
>starts with 270 msec and drops to 29 msec again.
>
>Any clues about this interesting behaviour?
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sven Köhler | 2003-06-15 00:03:00 | Re: full featured alter table? |
Previous Message | Avi Schwartz | 2003-06-14 22:58:31 | Unknown kind of return type specified for function |