2010/7/12 Orvalho Augusto <orvaq...@gmail.com>: > Thanks!! > > That of restoring a database of huge size is not everyday you do. >
Well that depends :-) > I need people with databases of Postgres with sizes above 5GB. And tell us > how their postgres behave, specifically tell us how they address the vaccum > data thing. > Vacuum and analyze jobs are run as a daemon by default as far as I know. >From the postgres docs: Maximum Database Size Unlimited Maximum Table Size 32 TB Maximum Row Size 1.6 TB Maximum Field Size 1 GB Maximum Rows per Table Unlimited Maximum Columns per Table 250 - 1600 depending on column types Maximum Indexes per Table Unlimited So 5 GB should not be a problem.. > Please is not a war. > Definitely not :-) > Caveman > > > > > > 2010/7/12 Lars Helge Øverland <larshe...@gmail.com> >> >> Hi Caveman, we are definitely not dropping mysql support, its just >> that most of the devs are using postgres so a function not being >> mysql-compliant might sneak in from time to time. I tested most of the >> application on mysql recently without trouble. >> >> A common problem with aggregation earlier was the way the orgunit >> hierarchy was represented and stored, this is changed in 2.0.5 >> snapshot and is way less error-prone now. So please build yourself a >> war-file from trunk and test with that. >> >> If that doesn't work please send me a database dump and I will have a >> look. (On a sidenote a main reason for choosing postgres is the way >> dumps are restored - mysql uses single regular sql insert statements >> which might take days for very large databases while postgres uses >> more "native" copy statements which never takes more than minutes). >> >> cheers, Lars >> >> >> >> 2010/7/12 Orvalho Augusto <orvaq...@gmail.com>: >> > I need to have a repo/table that aggregates data as I asked before. I >> > did >> > not find it on docs. >> > >> > Someone told me that can happens if a generate those resource tables. I >> > try >> > to generate those tables and I get stuck on that error I reported. >> > >> > Good for me if I do not need to generate such tables and ask what I >> > should >> > do? >> > >> > Caveman >> > >> > >> > 2010/7/12 Lars Helge Øverland <larshe...@gmail.com> >> >> >> >> Generating any of the resource tables don't affect the aggregation / >> >> report tables... >> >> >> >> >> >> >> >> On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto <orvaq...@gmail.com> >> >> wrote: >> >> > Thanks!!! >> >> > >> >> > Caveman >> >> > >> >> > >> >> > On Sun, Jul 11, 2010 at 5:03 PM, Jason Pickering >> >> > <jason.p.picker...@gmail.com> wrote: >> >> >> >> >> >> A very common mistake is not having generated the resource tables, >> >> >> namely "orgunitstructure". Consult the documentation for more >> >> >> details >> >> >> on how to generate these tables. >> >> >> >> >> >> Regards, >> >> >> Jason >> >> >> >> >> >> >> >> >> On Sun, Jul 11, 2010 at 4:27 PM, Orvalho Augusto >> >> >> <orvaq...@gmail.com> >> >> >> wrote: >> >> >> > I have a dataelement collected at a Health Centre level (eg: >> >> >> > ats_posfem) >> >> >> > in >> >> >> > one province and only in some particular districts. In >> >> >> > unpredictible >> >> >> > future >> >> >> > at National level we will be collecting on every health centre. >> >> >> > >> >> >> > Now, my ignorance: How can I obtain the provincial total on Report >> >> >> > Table? I >> >> >> > have been battled with DHIS so far and nothing. >> >> >> > >> >> >> > Thanks guys >> >> >> > Caveman >> >> >> > >> >> >> > >> >> >> > _______________________________________________ >> >> >> > 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 >> >> >> > >> >> >> > >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> >> -- >> >> >> Jason P. Pickering >> >> >> email: jason.p.picker...@gmail.com >> >> >> tel:+260968395190 >> >> > >> >> > >> >> > >> >> > >> >> > _______________________________________________ >> >> > 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 >> >> > >> >> > >> > >> > >> > >> > > > > _______________________________________________ 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
