← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] DHIS 2, PostgreSQL only

 

Yes. The datavalue table is definitely a good candidate for partitioning.



On Thu, Nov 9, 2017 at 5:53 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:

> Very good Lars!  Looking at the move to postgresql 10 (presumably one
> or two more versions down the line), have you been considering the
> native partitioning support for dealing with huge datavalue tables?
> This looks like it might be very suited to our classic problem of
> large amounts of historic data..
>
> On 9 November 2017 at 20:47, Lars Helge Øverland <lars@xxxxxxxxx> wrote:
> >
> >
> > On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
> >>
> >> Good decision. I assume this means H2 will also no longer be a fallback?
> >> So dhis2 live will also require PG?
> >>
> >
> > We will continue to use H2 for internal purposes (unit testing) for a
> while,
> > and the system will still start and mostly work on H2. However there will
> > gradually be more features requiring PostgreSQL, and we hope to replace
> Live
> > with a Docker image in near future.
> >
> > As part of the move to PostgreSQL we will also require the PostGIS
> > extension.
> >
> >
> >
> > Lars
> >
> >
> >
> > --
> > Lars Helge Øverland
> > Lead developer, DHIS 2
> > University of Oslo
> > Skype: larshelgeoverland
> > lars@xxxxxxxxx
> > http://www.dhis2.org
> >
> >
> > _______________________________________________
> > 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
> >
>



-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>

References