| 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: | Whole Thread | Raw Message | 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 |