PostgreSQL 8.3 Released

jadavis writes "The release of the long-awaited PostgreSQL version 8.3 has been announced. The new feature list includes HOT, which dramatically improves performance for databases with high update activity; asynchronous commit; built-in full text search; large database features such as synchronized scans and reduced storage overhead; built-in SQL/XML support; spread checkpoints; and many more (too many major new features to list here). See the release notes for full details."

PostegreSQL 8.3?

[Anonymous Coward]

Would that be POSTGR~1.SQL?

Re:asynchronous committ

[Wesley Felter]

Haven't you heard? In Web 2.0, data integrity doesn't matter.

Re:And then...

[thrillseeker]

well, we will just have to polka holes in that discussion

Re:Nice.

[Seumas]

8.3 had me at "full-text search".

Now, please excuse me while Postgres 8.3 and I go take a little alone-time in a dark closet.

Re:Will it be used?

[ByteSlicer]

That, and people are more likely to remember 'My' than 'Postgre'.

Re:asynchronous committ

[plopez]

Why would you want to drop the durability part of ACID? Why would you risk losing data for speed?

SO you can write sloppy inefficient code and do sloppy DBA work and get away with it?

Just an idea.

Re:frist psot

[Anonymous Coward]

Verily sir, when it cometh to failing it, thou art truly a success.

MySQL is FAST, PgSQL FARTs on MySQL's Performance

[einhverfr]

Fast
And
Sorta
Transactional

PostgreSQL is
Fast
And
Really
Transactional

And under heavy loads with normalized db's PostgreSQL's planner does *much* better than MySQL's.

You are on to something.

[NotQuiteReal]

If PostgreSQL changed their name to OurSQL it would be easy to remember, and a sound a lot less selfish than MySQL.

Re:long live postgres

[David_W]

What do you think of: LLPP (Linux, lighttpd, Perl, PostgreSQL) or something like that.

My personal favorite is FAPP (FreeBSD, Apache, PostgreSQL, Perl).

...

What's so funny?

Re:Will it be used?

[Plaid Phantom]

You have a 100 GB database and you're not concerned with stability??

Do you work for the government?

Re:Cross Database Joins??

[dfetter]

I'm looking forward to the hooks you're working on that will make them more efficient :)