Re: Postgres performance comments from a MySQL user

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Arjen van der Meijden <acm(at)tweakers(dot)net>
Cc: "'scott(dot)marlowe'" <scott(dot)marlowe(at)ihs(dot)com>, "'Ernest E Vogelsinger'" <ernest(at)vogelsinger(dot)at>, "'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-16 20:35:28
Message-ID: 6571.1055795728@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Arjen van der Meijden <acm(at)tweakers(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-06-16 21:18:01 Re: RE : full featured alter table?
Previous Message Tom Lane 2003-06-16 20:20:55 Re: RE : full featured alter table?