Page 1 of 1

Change MariaDB for PostgreSQL

PostPosted: Thu Nov 17, 2016 12:55 pm
by macaruchi
Hi!
I am newbie using Vicidial and it is so cool but a question that I always have had is why dont change to Postgres?
I know maybe will be a huge work change the whole schema to another DB but really I think to use PG will be better. I am thinking to do this job, maybe just as exercise because I dont know , the integration level but will be interesting .

I have a few problems with lock table in MariaDB using MyISAM

Nobody has thought about this ?

Re: Change MariaDB for PostgreSQL

PostPosted: Thu Nov 17, 2016 2:36 pm
by mflorell
Yes, it has been thought about, but Vicidial is a real-time application, not transaction-based like most other applications, which is why we use the MyISAM engine. PostgreSQL is not a viable alternative for the way VICIdial is built. If you properly configure MariaDB on proper hardware, you can have very large VICIdial call centers handling millions of calls per day across hundreds of agents on dozens of servers with no problems.