Please create an account to participate in the Slashdot moderation system


Forgot your password?

Slashdot videos: Now with more Slashdot!

  • View

  • Discuss

  • Share

We've improved Slashdot's video section; now you can view our video interviews, product close-ups and site visits with all the usual Slashdot options to comment, share, etc. No more walled garden! It's a work in progress -- we hope you'll check it out (Learn more about the recent updates).


Comment: Re:So.. (Score 1) 344

by TheFuzzy (#33656556) Attached to: PostgreSQL 9.0 Released

Well, you can always do ad-hoc materialized views ... I'm coding some now.

However, better matview management is currently under development. We had a Google Summer Of Code project to write code to manage the updating of materialized views. In a couple of releases, we might have matviews as good as Oracle's.

Of course, if you're a PostgreSQL user and you want better matview support, then we could really use your help developing it.

--Josh Berkus
      PostgreSQL Project

Comment: Re:As always... (Score 1) 344

by TheFuzzy (#33643908) Attached to: PostgreSQL 9.0 Released


You're absolutely correct that such a comparison would be a real asset to users. However, it would also be a Herculean task. Several people have tried to do similar things, but the number of indexes you need to compare (features, reliability, performance, etc.) is too large. And some things are so different it's hard to compare them meaning fully. Imagine trying to do a head-to-head comparison of all OSes in every way.

Here's a few comparison links, but they just scratch the surface:

+ - PostgreSQL 9.0 released->

Submitted by
greg1104 writes "PostgreSQL 9.0 has been released today, including a pile of new features (with example usage for many). The biggest pair of features now included with the database allow near real-time asynchronous binary replication to slave nodes, along with the ability to run queries against them. Packages such as pgpool-II 3.0 have already been updated to build clusters using that feature, allowing transparent application load-balancing across multiple nodes for scaling read-heavy loads."
Link to Original Source

+ - PostgreSQL 8.4 Out->

Submitted by
TheFuzzy writes "PostgreSQL version 8.4 is now out and available for download. The main cool features in this version are: recursive queries (for doing trees etc.), windowing functions (for doing reports, more here), column-level permissions, parallel database restore (more here), a beta in-place upgrade tool, and a host of administrative improvements. And, of course, better performance, mainly on reporting queries. Some of the over 200 new or enhanced features are listed here."
Link to Original Source

+ - Finally ... PostgreSQL 8.4-> 1

Submitted by
TheFuzzy writes "Another year, another major release. The PostgreSQL development team has finally released PostgreSQL 8.4 (and there was much rejoicing). This version contains windowing functions for the Biz Intelligence types, and recursive queries for everyone else doing a web application. Postgres has also put a lot of work into changing many of the things which made it "hard to use" in the past. Try it and see if you agree."
Link to Original Source

"Text processing has made it possible to right-justify any idea, even one which cannot be justified on any other grounds." -- J. Finnegan, USC.