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.