Поиск и устранение проблем при эксплуатации потоковой репликации
Streaming replication has been introduced in 2010 and quickly became one of the most popular features of PostgreSQL. Today, it is hard to imagine PostgreSQL installation without streaming replication. With its stability, high efficiency and ease of configuration one would have thought it is an optimal feature. However, while using it you might sometimes enter murky waters. This often can be resolved by using a combination of built-in and third party troubleshooting tools. In my talk I will provide an overview of these tools and explain how with their help one can diagnose, understand and eliminate problems related to streaming replication. I will also go through the most frequent issues occurring when streaming replication is used and will propose possible solutions. This talk is primarily aimed at DBAs and system administrators who use PostgreSQL in their day-to-day.
VIDEO
Слайды
Другие доклады
-
45 мин
Marco Slot Citus DataУскоряясь до миллиона записей в секунду: масштабирование PostgreSQL с помощью Citus MX
Citus allows you to distribute postgres tables across many servers. It extends postgres to transparently delegate or parallelise work across a set of worker nodes, enabling you to scale out the CPU and memory available for queries.
One year ago, we began a long journey to allow Citus to scale out another dimension: write throughput. With writes being routed through a single postgres node, write throughput in Citus was ultimately bottlenecked on the CPUs of a single node. Citus MX is a new edition of Citus which allows distributed tables to be used from from any of the nodes, enabling NoSQL-like write-scalability.
-
45 мин
Darafei Praliaskouski JunoДвижущиеся цели в PostGIS
PostGIS enables spatial processing in Postgres. Usually PostGIS is used for planar euclidean calculations, but real world adds time, ambiguity and uncertainty. We'll have a look on making a thousand of cars move smoothly in real time on OpenStreetMap base map.
VIDEO
-
90 мин
Pavel Luzanov Postgres ProfessionalОбзор средств для отладки, профилирования и трассировки серверного кода
Debugging, profiling, and tracing of the executed commands play an important role in development of any applications. This is also true for developing stored procedures in DBMS.
PostgreSQL offers various tools (both built-in and external) for these purposes.
In this talk, we will provide an overview of the available tools and their advantages and disadvantages, as well as a detailed demo of their use cases.
This talk is a part of a basic course for backend application developers (DEV1), which “Postgres Professional” company plans to announce in the near future.
