Re: [ANNOUNCE] PostgreSQL 8.1.0 RPMs are available for

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Aly,

On Thu, 10 Nov 2005, Aly Dharshi wrote:

> I was just wondering if there will be any RPMs for x86-64, that would
> be grrrrreat.

We have RPMs for som x86-64 platforms on the FTP mirrors. For which
platform are you exactly looking for?

> Thanks for the wonderful job that you are doing Devrim.

I'm not alone in building the RPMs:

http://pgfoundry.org/project/memberlist.php?group_id=1000048

Regards,
- --
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDc80n4zE8DGqpiZARAhO2AKCgb7EPtfnXlpWBiHOqrHS1Q5dcUgCcDy+P
SQSY9U4+wxiuGvH2gR91W84=
=AGSm
-----END PGP SIGNATURE-----
>From pgsql-general-owner(at)postgresql(dot)org Thu Nov 10 19:29:11 2005
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 1BD19DB2C8
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Thu, 10 Nov 2005 19:29:10 -0400 (AST)
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 91678-05
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Thu, 10 Nov 2005 23:29:05 +0000 (GMT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.196])
by svr1.postgresql.org (Postfix) with ESMTP id 23F17DB291
for <pgsql-general(at)postgresql(dot)org>; Thu, 10 Nov 2005 19:29:06 -0400 (AST)
Received: by xproxy.gmail.com with SMTP id i30so602243wxd
for <pgsql-general(at)postgresql(dot)org>; Thu, 10 Nov 2005 15:29:10 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
s=beta; d=gmail.com;
h=received:date:to:subject:from:content-type:mime-version:content-transfer-encoding:message-id:user-agent;
b=F0jufK+tYww2BV3qEV4Rph2ZtQSgnMbGiGFrap8sFA/Hw7eHbxGne6Vah/oaQXVGUd2ir+AaWX6ElO7H97/lgBGA7yw6870zIFstfTBmWAus9qmHW44nRNHDXkA7tNVBOpxEaFjhqqR1vaTvJUeMSY/g5DaFfSVIQOLhIDC23aw=
Received: by 10.70.90.13 with SMTP id n13mr1215184wxb;
Thu, 10 Nov 2005 15:29:08 -0800 (PST)
Received: from localhost ( [68.191.211.177])
by mx.gmail.com with ESMTP id i33sm898622wxd.2005.11.10.15.29.08;
Thu, 10 Nov 2005 15:29:08 -0800 (PST)
Date: Thu, 10 Nov 2005 17:25:21 -0600
To: pgsql-general(at)postgresql(dot)org
Subject: Congratulations on 8.1
From: "Russ Brown" <pickscrape(at)gmail(dot)com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-1
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-ID: <op(dot)sz1sojru2ilifp(at)localhost>
User-Agent: Opera M2/8.50 (Linux, build 1358)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0 required=5 tests=[none]
X-Spam-Score: 0
X-Spam-Level:
X-Archive-Number: 200511/598
X-Sequence-Number: 86742

I'd just like to congratulate the team on the excellent job that they've
done on Postgresql 8.1.

Yet again I'm amazed by the progress made in each and every major release
of this product I've seen since I started using it (around version 7.0).

To single out the changes that jump out at me the most:

* I see the shared row locking as being a massive feature. I've had to
remove foreign keys in the past on high-volume databases because of FKeys
causing locks. This makes Postgres' already-excellent locking even better.

* The Bitmap scans are also a major improvement. Something that will have
a positive effect on existing databases and queries without re-writing
them, and will allow DBAs to reduce the number of multi-columns indices on
their tables.

* The last_id function is a very small addition but has a massive impact
on how easy it is to migrate applications from MySQL. I actually used this
myself the other day. I converted one application is a few hours whereas
it would have taken days without it (restructuring how new IDs are
returned).

* Faster aggregates is another area in which a huge gain has been made.

* I also see the GiST improvements as being very important.

I would like to make one suggestion regarding release notes. I would find
it extremely useful if the release notes contained links to the relevant
parts of the documentation that explain the new features. I often read
about a new feature and want to read more about it for more detail or to
find out how to use the new feature, but I then need to search through the
manual to find the relevant sections.

Once again: well done and thank you.

--

Russ