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