dhis2-devs team mailing list archive

[Orvalho Augusto <orvaquim@xxxxxxxxx>]

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 <larshelge@xxxxxxxxx>

> 2010/7/12 Orvalho Augusto <orvaquim@xxxxxxxxx>:
> > 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 <larshelge@xxxxxxxxx>
> >>
> >> 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 <orvaquim@xxxxxxxxx>:
> >> > 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 <larshelge@xxxxxxxxx>
> >> >>
> >> >> Generating any of the resource tables don't affect the aggregation /
> >> >> report tables...
> >> >>
> >> >>
> >> >>
> >> >> On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto <orvaquim@xxxxxxxxx
> >
> >> >> wrote:
> >> >> > Thanks!!!
> >> >> >
> >> >> > Caveman
> >> >> >
> >> >> >
> >> >> > On Sun, Jul 11, 2010 at 5:03 PM, Jason Pickering
> >> >> > <jason.p.pickering@xxxxxxxxx> 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
> >> >> >> <orvaquim@xxxxxxxxx>
> >> >> >> 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@xxxxxxxxxxxxxxxxxxx
> >> >> >> > Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> >> >> > More help   : https://help.launchpad.net/ListHelp
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> --
> >> >> >> Jason P. Pickering
> >> >> >> email: jason.p.pickering@xxxxxxxxx
> >> >> >> tel:+260968395190
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> > _______________________________________________
> >> >> > Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> >> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> >> > Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> >> > More help   : https://help.launchpad.net/ListHelp
> >> >> >
> >> >> >
> >> >
> >> >
> >> >
> >> >
> >
> >
> >
>