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 E9DF3D1B787 for ; Sun, 25 Jul 2004 21:13:57 -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 67861-08 for ; Mon, 26 Jul 2004 00:12:40 +0000 (GMT) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 147A5D1B758 for ; Sun, 25 Jul 2004 21:12:23 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id i6Q0COr16259; Sun, 25 Jul 2004 20:12:24 -0400 (EDT) From: Bruce Momjian Message-Id: <200407260012.i6Q0COr16259@candle.pha.pa.us> Subject: Re: 7.5 release notes In-Reply-To: <1090752696.1676.212.camel@jeff> To: Jeff Davis Date: Sun, 25 Jul 2004 20:12:24 -0400 (EDT) Cc: 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=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200407/44 X-Sequence-Number: 2452 Jeff Davis wrote: > On Sat, 2004-07-24 at 21:25, Bruce Momjian wrote: > > I have completed the 7.5 release notes. You can view them in HTML on > > the developer web page. I have marked a few items with question marks > > that need to be addressed. I am looking for improvements, even minor > > ones. Either send in a patch or committers can modify the file > > directly. > > I don't understand the following passage: > > "When matching GROUP BY names, prefer local FROM columns first, then > SELECT aliases, and then outer FROM columns (Tom) > > This change was made because it is considered more consistent than the > previous behavior." > > Perhaps it could be more clear? I don't know where else I'd go to find > more thorough documentation on that subject. Item removed. Tom said it was already in 7.4.3. I made the adjustments below. --------------------------------------------------------------------------- > > Also, I've included a couple typo fixes below. > > Regards, > Jeff Davis > > --- release.html.old 2004-07-25 03:06:28.000000000 -0700 > +++ release.html 2004-07-25 03:10:21.000000000 -0700 > @@ -99,7 +99,6 @@ >

Before this change some queries would not use an > index if the data > types did not exactly match. This improvement makes index usage > more > intuitive and consistent. > - match exactly >

  • New buffer replacement strategy that > improves caching (Jan) >

    Prior releases use a least-recently-used (LRU) cache > to keep > recently referenced pages in the cache. Unfortunately, the cache > @@ -129,7 +128,7 @@ > 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. > + difficult for closed-source companies to emulate. >

  • Improve btree index performance for > duplicate keys (Dmitry Tkach, Tom) >

    This improves the way indexes are scanned when many > duplicate values exist in the index. > > > -- 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