PostgreSQL v7.4 Released

[Marc G. Fournier]

After almost 12 months of intense development, and testing, we are proud
to announce the availability of PostgreSQL v7.4.

An overview of the major changes in v7.4 include:

IN/NOT IN subqueries are now much more efficient
Improved GROUP BY processing by using hash buckets
New multikey hash join capability
Queries using the explicit JOIN syntax are now better optimized
Faster and more powerful regular expression code
Function-inlining for simple SQL functions
Full support for IPv6 connections and IPv6 address data types
Major improvements in SSL performance and reliability
Make free space map efficiently reuse empty index pages, and other
SQL-standard information schema
Cursors conform more closely to the SQL standard
Cursors can exist outside transactions
New client-to-server protocol
libpq and ECPG applications are now fully thread-safe
New version of full-text indexing
New autovacuum tool
Array handling has been improved and moved into the server core

For a full listing of what has changed between v7.3 and v7.4, please see
the HISTORY file available at:

http://developer.postgresql.org/~momjian/HISTORY.html

For a look at the Official Press Release that our Advocacy team *slaved*
over for the many weeks preceeding the release, it is available at:

http://www.postgresql.org/presskit/en/presskit74.html

For this release, we have two primary methods of downloading, in two
different formats ...

For those using BitTorrent (http://bitconjurer.org/BitTorrent/), we have
setup a BitTorrent server at:

http://bt.postgresql.org

For those using FTP, please see our listing of mirror sites for a location
near you:

http://www.postgresql.org/mirrors-www.html

And, due to popular demand over the years, we've finally given in and are
offering both .gz and .bz versions, both through FTP and BitTorrent.

Any questions/problems with release, please report them, as always, to
pg********@post gresql.org.

Marc G. Fournier
Coordinator
PostgreSQL Global Development Group
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Peter Eisentraut]

Marc G. Fournier writes:

After almost 12 months of intense development, and testing, we are proud
to announce the availability of PostgreSQL v7.4.
And when will the coordinator learn that it is called "PostgreSQL 7.4" and
not "PostgreSQL v7.4"?
For a full listing of what has changed between v7.3 and v7.4, please see
the HISTORY file available at:

http://developer.postgresql.org/~momjian/HISTORY.html

Better known as

http://www.postgresql.org/docs/7.4/static/release.html

--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[Marc G. Fournier]

On Mon, 17 Nov 2003, Peter Eisentraut wrote:

Marc G. Fournier writes:

After almost 12 months of intense development, and testing, we are proud
to announce the availability of PostgreSQL v7.4.

And when will the coordinator learn that it is called "PostgreSQL 7.4" and
not "PostgreSQL v7.4"?

Habit :)
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[Peter Eisentraut]

Marc G. Fournier writes:

And when will the coordinator learn that it is called "PostgreSQL 7.4" and
not "PostgreSQL v7.4"?

Habit :)

I would appreciate it if you could abandon that habit and stop making us
look like losers.

--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[terry]

Interesting, I see the difference between "PostgreSQL v7.4 Released" and
"PostgreSQL 7.4 Released".

But I didn't perceive a "loser" until the Postgres team started squabbling
amongst themselves on a public forum about it.

Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
te***@greatgulf homes.com
Fax: [phone]

-----Original Message-----
From: pg************* ****@postgresql .org
[mailto:pg****** ***********@pos tgresql.org]On Behalf Of Peter
Eisentraut
Sent: Monday, November 17, 2003 6:35 PM
To: Marc G. Fournier
Cc: pg***********@p ostgresql.org
Subject: Re: [GENERAL] PostgreSQL v7.4 Released
Marc G. Fournier writes:

And when will the coordinator learn that it is called "PostgreSQL 7.4" and not "PostgreSQL v7.4"?

Habit :)

I would appreciate it if you could abandon that habit and
stop making us
look like losers.

--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
ma*******@postg resql.org

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Reece Hart]

On Mon, 2003-11-17 at 15:35, Peter Eisentraut wrote:

I would appreciate it if you could abandon that habit and stop making us
look like losers.

Losers? PostgreSQL is way too good for it to be the product of losers.
My Oracle-bound comrades have drooled over things like table inheritance
and server-side functions in perl and python. I can tell you that
they're the ones who've felt like they're losing something.

Hackers, thanks again for 7.4 (and Marc, thanks for v7.4).

-Reece
--
Reece Hart, http://www.in-machina.com/~reece/, GPG:0x25EC91A0

[Marc G. Fournier]

On Tue, 18 Nov 2003, Peter Eisentraut wrote:

Marc G. Fournier writes:

And when will the coordinator learn that it is called "PostgreSQL 7.4" and
not "PostgreSQL v7.4"?

Habit :)

I would appreciate it if you could abandon that habit and stop making us
look like losers.

Odd that you are the only one that *ever* seems to take offence at it ...
*shrug*

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Gianni Mariani]

te***@ashtonwoo dshomes.com wrote:

Interesting, I see the difference between "PostgreSQL v7.4 Released" and
"PostgreSQL 7.4 Released".

But I didn't perceive a "loser" until the Postgres team started squabbling
amongst themselves on a public forum about it.

No losers here :-)

Great job guys !

..Sig - Speeling impaired welcome here.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Marc G. Fournier]

On Mon, 17 Nov 2003 te***@ashtonwoo dshomes.com wrote:

Interesting, I see the difference between "PostgreSQL v7.4 Released" and
"PostgreSQL 7.4 Released".

And, until Peter pointed it out to you, did you notice the difference?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Peter Eisentraut]

Marc G. Fournier writes:

Odd that you are the only one that *ever* seems to take offence at it ...
*shrug*

Here it's just the release announcements that make us look like some kind
of weirdos. But when you're making tarballs like erserver_v1.2.t ar.gz
then you're not only making a fool of yourself, you're creating actual
technical problems. I take offense at it because for years you've simply
ignored all requests to do something about it. But I'm certainly not the
only one who considers it odd.

--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org