5 ms·
> but have missed some of the things that MSSQL makes very easy, and by comparison PostgreSQL makes relatively hard. Could you give some examples?
by insulanian 10y ago
> but have missed some of the things that MSSQL makes very easy, and by comparison PostgreSQL makes relatively hard.
Could you give some examples?
- tracker1 10y agoNamely in the box replication and failover (like checkbox interaction via the GUI) compared to a hard to configure, or expensive to license add-on. IIRC geo indexing was easier in mssql, although much more configurable in pgsql. Not on pg, but linq to entities for .net is really nice, and the pg adapter (iirc) wasn't nearly as good. The node adapters for each are about equal though. Out of the box performance on mssql, and query performance in general was better last time I compared (admittedly about 2 years ago).