r/programming • u/squareproton • Nov 16 '14
PostgreSQL vs. MS SQL Server - A comparison of two relational databases from the point of view of a data analyst
http://www.pg-versus-ms.com/
171
Upvotes
r/programming • u/squareproton • Nov 16 '14
1
u/rmxz Nov 21 '14 edited Nov 21 '14
On a system twice as large as you described, our experience porting from one of those systems to the other was described in another comment under this article, with both CPU and disk performance charts showing how drastically the system performed before and after the switch.
The TL/DR summary of that article is that porting to Postgres saved us from having to do rather expensive hardware upgrade because it was incredibly more efficient, thanks to GIST and GIN indexes which drastically reduced CPU load; far more compact storage of XML data saving lots of I/O; and writable CTEs meaning far more efficient inserts.