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
Thanks Saptarshi I am among of many who runs large DHIS2 database on MySQL. I always think to move back to PostgreSQL. This communication is of great enlightening to me. Congratulations Lungo From: Saptarshi Purkayastha To: DHIS 2 developers ; dhis2-us...@

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