Received: from nexus.kearneydev.com (IDENT:root@[208.136.214.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA86049 for ; Mon, 19 Jul 1999 10:20:28 -0400 (EDT) (envelope-from secret@kearneydev.com) Received: from kearneydev.com (atu.kearneydev.com [208.136.214.93]) by nexus.kearneydev.com (8.8.5/8.8.5) with ESMTP id KAA16171; Mon, 19 Jul 1999 10:15:56 -0400 Message-ID: <3793331B.21288516@kearneydev.com> Date: Mon, 19 Jul 1999 10:15:56 -0400 From: secret Organization: Kearney Development Co., Inc. X-Mailer: Mozilla 4.51 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Bruce Momjian CC: Jan Wieck , Patrik Kudo , pgsql-sql@postgreSQL.org Subject: Re: [SQL] Good Optimization References: <199907081548.LAA08995@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bruce Momjian wrote: > > 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, Pennsylvania 19026 Why not let the user select how much time he wants the DB to spend on optimization? maybe an explicit "FAST SELECT ..." will skip the costly steps for subsecond queries, or "OPTIMIZE SELECT" for the long(hour) queries that really need a lot of help :)... Or even a SET OPTION= for turning it on/off? --David