dhis2-devs team mailing list archive

[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
>> >> >> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> >> >> > Unsubscribe : https://launchpad.net/~dhis2-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
>> >> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> >> > Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> > More help   : https://help.launchpad.net/ListHelp
>> >> >
>> >> >
>> >
>> >
>> >
>> >
>
>
>