Which is best for 1c: Postgres or MSSQL?

Question

1C-Enterprise

There are quite a few divisions. There was a task to collect it all in one server. The total number is about 100-150. There are no restrictions on hardware yet, the authorities are ready to provide normal configurations. The question is which is better to use? I've read a lot about Postgres and MSSQL. But as a result of all the texts, as I understand it, the emphasis is on 1c to MSSQL when developing their products? Or am I wrong? Now it's all scattered across different computers. Somewhere on small servers, 4-6 pieces are spinning, and Postgres and MSSQL are the same everywhere.

Answer 1

Depending on what you are going to keep the servers on. If Linux is, then I would recommend PostreSQL, as I haven't seen anyone in their right mind use MSSQL under Linux, even though it exists.

Answer 2

We tried to transfer 1C to free OS and DBMS. We used one of the Russian Linux distributions based on CentOS, a Postgres build for 1C from Postgres Pro, a 1C server on the same Linux. Postgres was configured according to instructions from the Internet. Windows Server, SQL Server and 1C server were installed on similar hardware. Gilev's test was run on both systems. According to these tests, the system on Windows turned out to be about 2 times faster than on Linux. But maybe we just don't know how to set up systems on Linux.