Re: [SQL] Good Optimization - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: [SQL] Good Optimization
Date
Msg-id 199907081548.LAA08995@candle.pha.pa.us
Whole thread Raw
In response to Re: [SQL] Good Optimization  (wieck@debis.com (Jan Wieck))
List pgsql-sql
>     IMHO we're improving optimization more and more on  the  cost
>     of  query  parse/rewrite/optimize/plan time. Thus performance
>     of statements that EXECUTE fast slows  down  more  and  more.
>     Isn't   it   time   to   think   about  some  (maybe  shared)
>     "parsetree->plan" cache that provides ready to use  plans  if
>     only Const values have changed?

TODO list has:
* Cache most recent query plan(s?)

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] Good Optimization
Next
From: Olivier Ertz
Date:
Subject: RewriteDefine.c : Rule size