Good! Hope will not be a problem said like that.
Anyway we need people using it. It is not a doubt. We know that on India there are MySQL with more than 5GB. For vaccum yes postgres guys have daemonized the vaccum data clean. You are right. Caveman 2010/7/12 Lars Helge Øverland <larshe...@gmail.com> > 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<https://launchpad.net/%7Edhis2-devs> > >> >> >> > Post to : dhis2-devs@lists.launchpad.net > >> >> >> > Unsubscribe : > >> >> >> > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-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<https://launchpad.net/%7Edhis2-devs> > >> >> > Post to : dhis2-devs@lists.launchpad.net > >> >> > Unsubscribe : > >> >> > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-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
