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