On Mon, Sep 01, 2008 at 10:31:25AM +0200, Thomas Kellerer wrote: > Scott Marlowe, 31.08.2008 22:44: >> I think some of it is inertia. We've always used Oracle, let's >> just keep on using it. The more conservative the IT department is, >> the less likely they are to take chances with new technology. >> >> It used to be there was about an 80/20 split between what things >> you could do with either postgresql or oracle, and the other 20% >> was oracle only land. I think that number is dropping quickly, and >> we're into the 1 or 2% club of what Oracle can do that PostgreSQL >> isn't fast enough for. > > For me (personally) the ratio is more like 70/30, It's about to increase :) > because we are making extensive usage of Oracle's windowing > functions http://umitanuki.net/pgsql/wfv04/design.html > (and ability to easily deal with hierarchical data using CONNECT BY). It's even more fun with CTEs. <http://wiki.postgresql.org/wiki/CTEReadme> > The lack of windowing functions is a bit frustrating as I'm > otherwise a big Postgres fan! Those will both be fixed, at least to a large degree, in 8.4 :) Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
