On Sat, Apr 12, 2008 at 8:44 AM, Perez <arturo@ethicist.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@postgresql.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.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/
