postgresql 7.1

What;s the new in Postgresql 7.1 ?

Asidha Luhwidyanto

"Martin A. Marques" wrote:

On Wed, 11 Oct 2000, Martin A. Marques wrote:

How far are we from seeing the version 7.1 out?

beta starts ~Nov 1st, release in January ...

On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote:

What;s the new in Postgresql 7.1 ?

TOAST and WAL!!!!

I think these are big changes that will make me think about postgresql as a
big time competitor against the big commercial database engines.

WAL is a backup system.
TOAST is a system for working with rows that have to use more then the 8K
limitation.
AFAIK!

--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Mart�n Marqu�s email: martin@math.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

* Martin A. Marques <martin@math.unl.edu.ar> [001011 19:10] wrote:

On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote:

What;s the new in Postgresql 7.1 ?

TOAST and WAL!!!!

I think these are big changes that will make me think about postgresql as a
big time competitor against the big commercial database engines.

WAL is a backup system.

afaik WAL means the end of the dreaded 'vacuum', it allows the system
to reuse free space without explicitly scanning the datafiles, it should
also do it in a manner that still allows transactional dumping.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

On Wed, 11 Oct 2000, Tim Uckun wrote:

At 11:04 PM 10/11/2000 -0300, Martin A. Marques wrote:

On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote:

What;s the new in Postgresql 7.1 ?

TOAST and WAL!!!!

I think these are big changes that will make me think about postgresql as a
big time competitor against the big commercial database engines.

WAL is a backup system.
TOAST is a system for working with rows that have to use more then the 8K
limitation.
AFAIK!

What happened to outer joins? Don't you need outer joins to compete with
the big boys?

tom lane has been working aggressively on that :)

At 11:04 PM 10/11/2000 -0300, Martin A. Marques wrote:

On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote:

What;s the new in Postgresql 7.1 ?

TOAST and WAL!!!!

I think these are big changes that will make me think about postgresql as a
big time competitor against the big commercial database engines.

WAL is a backup system.
TOAST is a system for working with rows that have to use more then the 8K
limitation.
AFAIK!

What happened to outer joins? Don't you need outer joins to compete with
the big boys?
----------------------------------------------
Tim Uckun
Mobile Intelligence Unit.
----------------------------------------------
"There are some who call me TIM?"
----------------------------------------------

Tim Uckun <tim@diligence.com> writes:

What happened to outer joins? Don't you need outer joins to compete with
the big boys?

They're done too ;-)

regards, tom lane

At 01:37 AM 10/12/2000 -0400, Tom Lane wrote:

Tim Uckun <tim@diligence.com> writes:

What happened to outer joins? Don't you need outer joins to compete with
the big boys?

They're done too ;-)

Wooo Hooo time to break out the champagne!
----------------------------------------------
Tim Uckun
Mobile Intelligence Unit.
----------------------------------------------
"There are some who call me TIM?"
----------------------------------------------

So a new version will be out soon. How often Bruce's book will be revised?
With each new version?

----- Original Message -----
From: "Tim Uckun" <tim@diligence.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, October 12, 2000 5:43 AM
Subject: Re: [GENERAL] postgresql 7.1

At 01:37 AM 10/12/2000 -0400, Tom Lane wrote:

Tim Uckun <tim@diligence.com> writes:

What happened to outer joins? Don't you need outer joins to compete

with

Martin A. Marques writes:

How far are we from seeing the version 7.1 out?

Beta is supposed to be November 1st. Personally, I'm putting my chips on
a February 1st release.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

The Hermit Hacker writes:

How far are we from seeing the version 7.1 out?

beta starts ~Nov 1st, release in January ...

Just wondering, WAL is going to be integrated when, and that gives how
much time to test it before releasing the beta?

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

[ Charset ISO-8859-1 unsupported, converting... ]

So a new version will be out soon. How often Bruce's book will be revised?
With each new version?

Good question. I know the initial printing run was reduced, perhaps so
new editions could be made.

I do the entire book here, and deliver camera-ready copy, so the process
of generating a new edition is pretty easy.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

This sort of thing had crossed my mind because of sendmail (among many other
open source projects). Tring to get up to date info on running it (8.10
version) and the "BEST" book out there is 8.x version, which really is not
too relevant for 8.10 features.

Versioning changes often as well as new features and revisions of old ones.
Also, compilation issues always change from release to release. For a
publishing company it would be expensive to constantly put out a book for
each version that entails everything. Plus, consumers really don't want to
keep buying the same material over and over again.

For prohjects such as this that have commercial documentation, why don't
they have "patches" for printed books also?

Example, Software 1.0, author releases a full fledged book called Software
1.0 Bible. Contains compiling issues, how to use the software, etc. All
that you could want from a 40-60 dollar book. Software 1.1 is release 3
months later. After that author writes a short and concise book titled
Software Bible from 1.0 to 1.1. Doesn't cover the same info as 1.0 Bible.
Goes into as much detail as the first book did, but only involving new info
pertaining to 1.1 (and mayhaps a chapter on upgrading from 1.0 to 1.1). So
instead of another 400 page book, maybe it is only 100, depending on the new
feature set from version to version. Book assumes you HAVE read 1.0 Bible or
know enough about 1.0 where you don't need it.

Software keeps doing releases and the same production release for books
follows. After two years, Software 2.0 comes out (implying a significant
version difference from 1.0). A new book is written (re-written) and it
starts from scratch and called Software 2.0 Bible. Same book "patch"
schedule is followed as previously, etc.

It would be an interesting documentation project that would really keep
information organized and relatively accessible ('cause sometimes digging
through webpages and email groups is too time consuming).

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Efrain Caro" <betsemes@hotmail.com>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, October 12, 2000 11:29 AM
Subject: Re: [GENERAL] postgresql 7.1

[ Charset ISO-8859-1 unsupported, converting... ]

So a new version will be out soon. How often Bruce's book will be

revised?

How far are we from seeing the version 7.1 out?

beta starts ~Nov 1st, release in January ...

Just wondering, WAL is going to be integrated when, and that gives how

Hopefully, next week.

much time to test it before releasing the beta?

Vadim