Re: Need help building SQL query

Sugrue, Sean wrote:
> Who can I ask about large scale use of postgresql installations in a
> large company? What are the gotchas? Why
> would you pay for Oracle if can use postgresql especially if it's just
> for data warehousing and not a transactional.

I'd state the opposite is the case. Oracle/DB2 is more compelling for
data warehousing but has little if no advantage in transactional
situations. You have more data partitioning capabilities with Oracle and
DB2 -- in a large enough install, those extra features may be a
significant performance win. (On the otherhand, you could throw extra
hardware at Postgres using the license costs so what's better/faster
depends on the exact situation.)

For transactional DBs, there's no compelling advantage at all (other
than CYA w/ PHBs). Everybody has triggers/rules/stored
procs/etc/etc/etc. Multi-master replication at the LAN level is the only
feature I can think of that's missing from Postgres that could be used
for transaction systems.