PostgreSQL 8.2 Released - Slashdot

Want to read Slashdot from your mobile device? Point it at m.slashdot.org and keep reading!

×

PostgreSQL 8.2 Released 147

Posted by kdawson on Tuesday December 05, 2006 @08:10PM from the faster-so-they-say dept.

An anonymous reader writes to let us know that PostgreSQL 8.2 has been released (bits, release notes). 8.2 is positioned as a performance release. PostgreSQL it is still missing the SQL:2003 Window Functions that are critical in business reporting, so Oracle and DB2 will still win out for OLAP/data warehouse applications.

This discussion has been archived. No new comments can be posted.

PostgreSQL 8.2 Released

Search 147 Comments Log In/Create an Account

Comments Filter:

Re:bitmap? (Score:1, Funny)

by jrockway ( 229604 ) writes: <jon-nospam@jrock.us> on Tuesday December 05, 2006 @08:45PM (#17122380) Homepage Journal

Sure would be nice if you sent in a patch.

Parent Share
twitter facebook
Re:Real Men don't use Window Functions (Score:4, Funny)

by larry bagina ( 561269 ) writes: on Tuesday December 05, 2006 @08:46PM (#17122384) Journal

According to the MySQL fanbois, Window Functions are bad for performance and not even useful. Just like subselects, data integrity, triggers, and transactions. Oh wait, MySQL 5 supports subselects. Subselects are no longer bad for performance.

Parent Share
twitter facebook
Re:Performance? (Score:5, Funny)

by greg1104 ( 461138 ) writes: <gsmith@gregsmith.com> on Tuesday December 05, 2006 @11:08PM (#17123732) Homepage

How fast is it against MyISAM?

I've managed to get my PostgreSQL installation tuned to very high speeds simply by switching the database disk over to /dev/null. It runs fast as hell, and the data integrity is basically the same as MyISAM.

Parent Share
twitter facebook
One thing you cant do in PostgreSQL ... (Score:2, Funny)

by euice ( 953774 ) writes: on Wednesday December 06, 2006 @04:41AM (#17126002)

... is create a smallint index on an int column ;-)

Share
twitter facebook

There may be more comments in this discussion. Without JavaScript enabled, you might want to turn on Classic Discussion System in your preferences instead.

Related Links Top of the: day, week, month.

413 commentsChatGPT Leans Liberal, Research Shows
347 commentsAmazon CEO Says 'It's Probably Not Going To Work Out' For Employees Who Defy Return-to-Office Policy
327 commentsHotel Owners Start To Write Off San Francisco as Business Nosedives
323 commentsChina is Building Nuclear Reactors Faster Than Any Other Country
315 commentsChina is Calling in Loans To Dozens of Countries

The rule on staying alive as a program manager is to give 'em a number or give 'em a date, but never give 'em both at once.