Yes. The datavalue table is definitely a good candidate for partitioning.
On Thu, Nov 9, 2017 at 5:53 PM, Bob Jolliffe <bobjolli...@gmail.com> 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 <l...@dhis2.org> wrote: > > > > > > On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring <knu...@gmail.com> 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 > > l...@dhis2.org > > http://www.dhis2.org > > > > > > _______________________________________________ > > 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 > > > -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland l...@dhis2.org http://www.dhis2.org <https://www.dhis2.org/>
_______________________________________________ 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