# postgres 9.2

**URL:** <https://community.dhis2.org/t/postgres-9-2/16506>\
**Category:** Support - Assistance technique\
**Created:** [12 September 2012 09:43 UTC](https://community.dhis2.org/t/postgres-9-2/16506 "2012-09-12T09:43:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lars](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/lars/32/34166_2.png) [@Lars](https://community.dhis2.org/u/Lars)\
**Post date:** [12 September 2012 09:43 UTC](https://community.dhis2.org/t/postgres-9-2/16506/1 "2012-09-12T09:43:34Z")

</div>

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](http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2)

---

<div class="post-metadata">

**Author:** ![Knut\_Staring](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/knut_staring/32/32549_2.png) [@Knut\_Staring](https://community.dhis2.org/u/Knut_Staring)\
**Post date:** [12 September 2012 10:58 UTC](https://community.dhis2.org/t/postgres-9-2/16506/2 "2012-09-12T10:58:29Z")

</div>

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
> > 
> > [What's new in PostgreSQL 9.2 - PostgreSQL wiki](http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2)
> > 
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Mailing list: [DHIS 2 developers in Launchpad](https://launchpad.net/~dhis2-devs)  
> > Post to : dhis2-devs@lists.launchpad.net  
> > Unsubscribe : [DHIS 2 developers in Launchpad](https://launchpad.net/~dhis2-devs)  
> > More help : [ListHelp - Launchpad Help](https://help.launchpad.net/ListHelp)
> 
> --  
> Knut Staring  
> Dept. of Informatics, University of Oslo  
> +4791880522
> 
> > **[Home - DHIS2](https://dhis2.org)**
> >
> > Collect, visualize and analyze your data with DHIS2, the world's largest health information management system, a global public good.