Re: Cached Query Plans (was: global prepared statements)

On Sat, Apr 12, 2008 at 8:44 AM, Perez <arturo(at)ethicist(dot)net> wrote:
> Doesn't Oracle do this now transparently to clients?

Of course it does, and it has since the late 80's I believe.

> Oracle keeps a statement/plan cache in its shared memory segment (SGA)
> that greatly improves its performance at running queries that don't
> change very often.

Yep.

> From that point of view, Oracle at least sees benefits in doing this.

Yes, it is also a bit more advanced than we're discussing here, so
I'll just leave it as.

> From my POV a transparent performance enhancer for all those PHP and
> Rails apps out there.

Yes.

>
> With plan invalidation in 8.3 this becomes feasible for pgSQL to do as
> well.
>
> -arturo
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah(dot)harris(at)enterprisedb(dot)com
Edison, NJ 08837 | http://www.enterprisedb.com/