Re: Success Story : French Social Services now using PostgreSQL - Mailing list pgsql-advocacy

Le 13/09/2010 15:05, damien clochard a écrit :
> hi,
>
> The news went out in France in june, somehow i forgot to forward it here...
>
> The CNAF (one of the biggest part of the french social system) has
> successfully migrated its legacy COBOL applications to PostgreSQL.
>
> The whole migration took several years and was driven by BULL with the
> help of Dalibo.
>
> Here's a few figures to describe the use case :
>
>   * 37 millions people concerned (half of the french population)
>   * 2,5 billions euros paid every month, based on the data stored by
> PostgreSQL
>   * 1 billion SQL statements every day
>

i got more details yesterday after talking with someone at Bull :

   * the whole system is split into approx. 246 databases ( 2 for each
local administration of the social services )
   * the size of the biggest database is 250 Go.


--
damien clochard