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

From Mark Kirkwood
Subject Re: Postgres performance comments from a MySQL user
Date
Msg-id 3EEBA998.9060307@paradise.net.nz
Whole thread Raw
In response to Re: Postgres performance comments from a MySQL user  (Ernest E Vogelsinger <ernest@vogelsinger.at>)
List 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?
>
>
>
>


pgsql-general by date:

Previous
From: Avi Schwartz
Date:
Subject: Unknown kind of return type specified for function
Next
From: Sven Köhler
Date:
Subject: Re: full featured alter table?