postgres 9.2

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's_new_in_PostgreSQL_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@gmail.com> 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's_new_in_PostgreSQL_9.2

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
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