← Back to team overview

dhis2-devs team mailing list archive

Re: postgres 9.2

 

Thanks, looks very interesting.

Given the increased data volumes, does this new version strengthen the
argument for standardizing on Postgres rather than continue our old
principle of trying to be database agnostic? In other words, does the
hibernate thing cost us a too much in terms of performance loss, when
we could push more processing to the db?

It would also allow us to take advantage of things like PostGIS.

Knut

On Wed, Sep 12, 2012 at 11:43 AM, Lars Helge Øverland
<larshelge@xxxxxxxxx> wrote:
> Postgres 9.2 is out with improvements like
>
> - index-only scans (not reading from table if all data is in index,
> means we can e.g. make indexes covering the whole data mart to speed
> up queries)
>
> - new JSON data type
>
> - improved master-slave replication
>
> - linear scalability to 64 cores
>
> http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp



-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org


References