Re: [Dhis2-devs] Migrating from MySQL to PostgreSQL

2013-05-07 Thread Bharath
Thanks Saptarshi, this is very helpful. On Tue, May 7, 2013 at 6:23 PM, Saptarshi Purkayastha wrote: > Hello DHIS users and devs, > > Apologies for the long email... Should have probably been multiple > blogpost to reduce its length... > > I recently encountered a situation with a very large imp

Re: [Dhis2-devs] Migrating from MySQL to PostgreSQL

2013-05-07 Thread Orvalho Augusto
Thank you again! Yes mysql might be better or not in another environment. Specially if we consider the number and sizes of files generated by your InnoDB settings. There is some discussion about how mysql could be affected by filesystem at http://serverfault.com/questions/29193/what-is-the-best-li

Re: [Dhis2-devs] Migrating from MySQL to PostgreSQL

2013-05-07 Thread Juma Lungo
...@lists.launchpad.net Sent: Tuesday, May 7, 2013 3:53 PM Subject: [Dhis2-devs] Migrating from MySQL to PostgreSQL Hello DHIS users and devs, Apologies for the long email... Should have probably been multiple blogpost to reduce its length... I recently encountered a situation with a very large

Re: [Dhis2-devs] Migrating from MySQL to PostgreSQL

2013-05-07 Thread Saptarshi Purkayastha
*PS: DO NOT COPY THESE AS IS IN YOUR PRODUCTION SYSTEM. THESE ARE SPECIFIC TO MY DEVELOPER INSTALLATION* Yes, these are on Windows and the results may or may not be different on Linux. The DHIS2 behavior would remain the same in its interaction with the database, since we are using the Type4 JDBC

Re: [Dhis2-devs] Migrating from MySQL to PostgreSQL

2013-05-07 Thread Orvalho Augusto
Wow! Weldone! I do not have a huge database as yours. And yes I have migrated from MySQL to postgreSQL because I felt that the DHIS community does not support enough MySQL. Anyway getting back to your journey I must ask what means tunned MySQL or tunned PostgreSQL? What you tune might dictate the

[Dhis2-devs] Migrating from MySQL to PostgreSQL

2013-05-07 Thread Saptarshi Purkayastha
Hello DHIS users and devs, Apologies for the long email... Should have probably been multiple blogpost to reduce its length... I recently encountered a situation with a very large implementation of DHIS2 having problems generating data mart. Thus no reports were generated and only data entry was