Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA75139 for ; Fri, 9 Jul 1999 13:10:53 -0400 (EDT) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id MAA01183; Fri, 9 Jul 1999 12:45:43 -0400 (EDT) From: Bruce Momjian Message-Id: <199907091645.MAA01183@candle.pha.pa.us> Subject: Re: Good Optimization In-Reply-To: <1BF7C7482189D211B03F00805F8527F70ED013@S-NATH-EXCH2> from "Ansley, Michael" at "Jul 9, 1999 12:15:09 pm" To: "Ansley, Michael" Date: Fri, 9 Jul 1999 12:45:43 -0400 (EDT) CC: "'pgsql-sql@postgresql.org'" X-Mailer: ELM [version 2.4ME+ PL56 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit [Charset iso-8859-1 unsupported, filtering to ASCII...] > Hi, Bruce, > > I've only just picked up the thread on optimizations (I get the digest for > the pgsql-sql list). I really feel that a lot of effort could be saved with > some good benefits if a stored proc mechanism is put into place. Once that > has been done, it can be used to store temporary plans (procedures) for > ad-hoc queries which are released on the termination of the connection. > However, I think that a lot of users will develop stored procs to replace a > lot of their existing common SQL, in order to (partially) optimize their > systems. Perhaps in the PREPARE statement we could add a facility to allow > the user to specify the TTL of the cached proc for an ad-hoc query. > > When I talk about stored procs, I don't mean functions. We already have > those. I mean procedures that are able to return a rowset. Just to make > sure nobody gets the wrong idea. Not sure why our functions can't return tuples. > Also, has anything happened about the idea to get PG to cluster (somebody > mentioned Beowulf)? No one has mentioned this. -- 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