Yes. The datavalue table is definitely a good candidate for partitioning.
On Thu, Nov 9, 2017 at 5:53 PM, Bob Jolliffe <[email protected]> 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 <[email protected]> wrote: > > > > > > On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring <[email protected]> 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 > > [email protected] > > http://www.dhis2.org > > > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~dhis2-devs > > Post to : [email protected] > > 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 [email protected] http://www.dhis2.org <https://www.dhis2.org/>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
