French social security now run on PostgreSQL and Red Hat Linux
According to a report from the Open Source Observatory and Repository for European public administrations (OSOR), France’s social security system, the Caisse Nationale d’Allocations Familiales (CNAF), is now using the open source PostgreSQL database management system (DBMS). The IT firm Bull is assisting CNAF and says that the PostgreSQL system is currently running nearly one billion SQL queries each day on Red Hat Linux servers.
Discussing the move, CNAF’s Deputy Director of Information Systems Marc Pavie said, “Our choice of PostgreSQL was not just driven by the fact that this software is open-source,” adding that, “This is a technically rich DBMS, that included all the features we need. It has levels of performance and reliability that meet our production goals”. Pavie goes on to note that it also allows his organisation to save costs on licences for a proprietary DBMS and to reduce its overall license budget. The move to the new systems took a total of 18 months to complete – 168 databases were migrated, representing 4 TB of data.