PgConf.Russia 2017 talks

Using PostgreSQL in UIS, CoMagic Projects

Dmitry Beloborodov
UIS, CoMagic, Technical Director

Dmitry is a technical director and development director of UIS and CoMagic projects. Holding the position, he is a team leader of strong PostgreSQL developers. They successfully solve wide range of tasks, from the choice of hardcore and PostgreSQL fine-tuning to sophisticated analytical queries optimization.

Using PostgreSQL since 2003, we went all the way from a database of a couple of GB to a cluster of more than 5TB. At the moment, we have more than 700 tables and about 1500 stored procedures. We are ready to share with you the following: - Problems encountered at different development stages and how we resolved them. - Best practices in database administration. - Our own extension to work with several closely related databases. - Best known methods and tools that enable our several teams to work together without interference. - How we set up test equipment of different types. And, of course, we'll talk about optimization, and how we identify bottlenecks and high-load use cases.