X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 687BDD1B76F; Sun, 25 Jul 2004 21:23:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73382-08; Mon, 26 Jul 2004 00:23:53 +0000 (GMT) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 5A48AD1B1A1; Sun, 25 Jul 2004 21:23:48 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id i6Q0NnV17904; Sun, 25 Jul 2004 20:23:49 -0400 (EDT) From: Bruce Momjian Message-Id: <200407260023.i6Q0NnV17904@candle.pha.pa.us> Subject: Re: [HACKERS] 7.5 release notes In-Reply-To: <14574.1090776361@sss.pgh.pa.us> To: Tom Lane Date: Sun, 25 Jul 2004 20:23:49 -0400 (EDT) Cc: Bruno Wolff III , PostgreSQL-development , PostgreSQL-documentation X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/48 X-Sequence-Number: 2456 \Tom Lane wrote: > Bruno Wolff III writes: > > In the following paragraph there appear to be two typos. I think > > "optimizer make" should be "optimizer makes" and that "lose-source" > > should be "closed-source". > > > It is difficult to explain all the optimizer improvements that go into a release like this. They involve complex adjustments to the logic used to select indexes, join methods, and join order. They are difficult to explain, but the result is that the optimizer make quicker and better choices in how to execute queries, resulting in improved performance. The close relationship between our developers and users reporting problems allows us to make rapid and complex optimizer improvements that would be very difficult for lose-source companies to emulate. > > I'd suggest removing the paragraph entirely, on the grounds that it is > content-free fluff. Hey, that's your content-free fluff. :-) You make major optimizer improvements in every release, but they are so complex it is impossible to explain them to people. This paragraph tries to address that. However, since you don't like it, I will remove it entirely. If you change your mind we can re-add it. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073