2 ms·
I am a platform architect in a large company that has a few hundreds TB database servers that are not on open-source software; we do use Postgres in about the s
by AdrianB1 6y ago
I am a platform architect in a large company that has a few hundreds TB database servers that are not on open-source software; we do use Postgres in about the same number of instances, but not for the core databases. There are several reasons for that, from tooling (SSMS has no competition) or simplicity to manufacturer support; for example, using MS SQL setting up high availability or replication is a matter of a few clicks (or a page of code) with no extra add-ons, packages etc. and these features are perfectly integrated in the database engine, supported by the same company, come in the same installer. Even for smaller databases we prefer the free edition of MS SQL, for development, testing or validation we use the free developer edition, so the cost is not that bad, while the product is much more simple, coherent and better supported and this matters when you do the math. The day Postgress will have an integrated tool as good as SSMS, high availability and replication seamlessly integrated and the ease of use for the operations team to keep it in good shape without highly skilled DBA's, I am the first in line to evaluate and deploy it. Until then, it is not good enough, even for free.