PostgreSQL versus Oracle
diznix.com
diznix.com
Microsoft: Champion of the persistent web!?
what?
Here is the google cache: http://webcache.googleusercontent.com/search?q=cache:Ge0OdZ2...
Does anyone know if text search performance is significantly different in the (as of 2012-04-23) latest version, 9.1.3?
Well, I guess they did. :-/
Of course, even if one lives in a jurisdiction where they're not, it would take some guts to stand up to Oracle's lawyers. And to convince your ISP, your government, etc. to stand up to Oracle's lawyers.
Does it have equivalent functionality to some of the more recent Oracle features like flashback queries and analytic functions (with windowing etc)? Are there any areas where Oracle clearly excels?
Nothing like Oracle's flashback queries. It used to have a feature called time travel which allowed you to look at historical versions of data, something they could do thanks to MVCC. It was removed, presumably because it caused performance issues or was too complex to maintain.
> There are several reasons for this: performance impact, storage size, and a pg_time file which grows toward infinite size in a short period of time.
Even so we are seeing very slow queries on our 8-node cluster, even for relatively simple queries and small datasets. It seems very sensitive to the result set size (ie., the maximum item number set in the query). A limit of 50 might take 500ms (which is slow but acceptable in our case) whereas 1000 results might take 3-4 seconds. The indexes are all in OS cache so disk performance is not the bottleneck.