Fault-tolerance cluster PostgreSQL + Patroni
I will speak about our experience in solving the fault-tolerance problem for PostgreSQL, which options we reviewed and how we chose Patroni.
I will cover solution testing, quick implementation to the production and issues we faced as well as the way we solved them.
Слайды
Видео
Другие доклады
-
Artem Ivanov Atos IT S&S
-
Kirill Borovikov ООО "Компания "Тензор"
Plan + query = ?.. Finding pleasure in analyzing query plans
Odd things in query plan analysis - wasted time and "unnecessary" buffers.
Structural hints in a plan. How to help a developer with optimization without writing a single line of code. How to match plan nodes with query text and take advantage of this information. -
Gregory Smolkin Postgres Professional
Database backup with pg_probackup
pg_probackup is a flexible tool that allows choosing the backup strategy depending on the write load of the PostgreSQL cluster, as well as offers a number of other features that can facilitate this vital aspect of database maintenance. In this tutorial, we will see how to apply this tool in practice.
-
Teodor Sigaev Postgres Professional