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

From Tom Lane
Subject Re: Postgres performance comments from a MySQL user
Date
Msg-id 6571.1055795728@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres performance comments from a MySQL user  (Arjen van der Meijden <acm@tweakers.net>)
Responses Re: Postgres performance comments from a MySQL user  (Arjen van der Meijden <acm@tweakers.net>)
List pgsql-general
Arjen van der Meijden <acm@tweakers.net> writes:
> Recent postgresql versions (7.3.3 perhaps? Dunno when it got included)
> cache the query-plans on the connection that was used for that
> connection.

There is absolutely no truth to the above statement.  There is no plan
caching (except in plpgsql, which has had it from the beginning).

You can get the effect of plan caching with prepared statements ...
but the OP didn't say anything about using PREPARE ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: RE : full featured alter table?
Next
From: "scott.marlowe"
Date:
Subject: Re: RE : full featured alter table?