On Sat, Apr 12, 2008 at 8:44 AM, Perez <[EMAIL PROTECTED]> 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 | [EMAIL PROTECTED] Edison, NJ 08837 | http://www.enterprisedb.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
