Re:Why Use Postgres
by josephcooney on Monday April 30, 2012 @08:15PM
(#3912287)
A lot of 'enterprise' products take this route so they can be deployed on top of your RDBMS of choice (Oracle, DB2). They usually get pretty terrible performance out of their RDBMS as a result.
[ Parent
| on HN ]
In fact they tend to optimise per engine.
If you look at NHibernate for example, if you do paging on SQL 2005+ it will use CTE yet on MySQL it will use LIMIT clauses underneath.
Some enterprise products have a really crappy schema with an ORM thrown over the top - that's where the pain is.
Re:Why Use Postgres
by josephcooney on Tuesday May 01, 2012 @08:49PM
(#3917097)
Your definition of 'enterprise' might be different to mine. I'm thinking of SAP and PeopleSoft. And I think the crappy schema arises (sometimes) from not wanting to use any proprietary DDL features.