Dear friends, in 3 days, on the June 1st the prices for the tickets will increase. If you plan to participate in the conference, now is about time to purchase tickets with up to 25% discount!
Meanwhile, we want to present you a digest of the upcoming talks that were announced this week.
1) "Means of diagnosing PostgreSQL»
Here is a report of Vladimir Borodin from Yandex and Ildus Kurbangaliev of Postgres Professional dedicated to means for diagnosing PostgreSQL.
Vladimir will talk about two scenarios.
1. Your monitoring blew up with notifications of events on the mission-critical database. What do you have to look for understand ASAP what have happened? And what kinds of open source tools might be used for this purpose.
2. You regularly run into a performance problem with PostgreSQL. What can be done after you've read the documentation and searched the Internet to no avail, before you turn to asking the collective mind in the pgsql- * mailing lists?
Whereas Ildus will demonstrate specific examples of how the 9.6 will bring qualitative improvements in resolution of the problems that are described above.
2) "How to monitor PostgreSQL and the world that surrounds it"
How to monitor PostgreSQL? Which metrics to rely upon? How to facilitate immediate display of apparent causes of the problem in your monitoring?
What's to blame, a heavy query or slow discs? Did modification of settings help to alleviate issues on the entire database or only for specific requests? Did the performance improve or degrade after a release of application? How to collect and visualize everything in the right way, which triggers can and should be set up for this job?
These and many other questions at the upcoming PG Day'15 will be answered by Pavel Truhanov from OKMeter, who will analyze examples of real-world problems on databases of the various RUnet projects.
3) "Using PostgreSQL statistics to optimize performance"
Colleagues from PostgreSQL-Consulting, who have to confront problems of large-scale optimization on a daily basis, will share their experiences at the upcoming PG Day'15.
Alexei Yermakov, one of the company's DBAs, will talk about the application of statistics in PostgreSQL for performance optimization. Statistical information collected by PostgreSQL produces a great impact on system performance. Knowing the data distribution statistics, the optimizer can estimate correctly the number of required rows, amount of memory needed and choose the fastest query execution plan.
In addition to information about the distribution of data, PostgreSQL also gathers statistics about accesses to tables and indexes, function calls and even individual request calls. In his talk Alex shows how statistical information is collected, why is it so important and how to read and interpret it correctly; what parameters can you tweak in specific cases, how to choose the optimal indexes and how to rewrite a query to correct a mistake of the scheduler.
4) "How to cook Rails for PostgreSQL the right way"
Frameworks and databases - always a hot topic. ORM: to be or not to be? How to write queries in a correct manner? How to teach your favorite tool to work with the advanced functions of the database?
In his talk, Stepan Kiryushkin will tell about all the different ways to prepare Rails for Postgres. Hot and non-trivial topics only: different approaches to deployment of database schema in RoR + PG, their pros and cons; what's different in how the 3 and 4 versions of the framework work with PG; what to do if you've decided to upgrade your application to the fourth version, and much more.
Subscribe to news and events:
