Upcoming presentations
No upcoming presentations...
Past presentations
Built-in logical replication is coming to PostgreSQL 10! This talk will introduce this new headline feature, demonstrate the use, and discuss the current status and future plans for logical replication in PostgreSQL.
2ndQuadrant Workshop: Logical replication deep dive
A look deep inside pglogical, BDR, in-core logical replication
This talk will take a closer look at the implementation of logical replication solutions for PostgreSQL: pglogical, BDR, and in-core logical replication in PostgreSQL 10. We will talk about the roles of logical decoding, replication slots, replication origins, commit timestamps, custom WAL records, and other pieces that make these systems work. We'll contrast these systems with trigger-b...
How do we know PostgreSQL works? What do "regression tests", "isolation tests", "TAP tests" do? What does the build farm do? What is the community's role in testing? What are the strengths and weaknesses of the testing methodologies and tools and how can we improve them? I invite all existing hackers to join me so we can share our experiences and visions. For users who are not yet hackers, this...
PgBouncer is primarily thought of as a connection pooler, but it can be much more. As a key component in many high-performance PostgreSQL installations, PgBouncer can help with connection routing, queuing, load management, and database maintenance. Learn how to use PgBouncer, how to configure it for the right application, how to monitor it appropriately, what errors to look for, and when to con...
If you feel stuck with the likes of Nagios and Munin, then Sensu might be for you. Sensu is a new open-source monitoring framework built with and for modern technology. Learn how it works and how you can use it to monitor your PostgreSQL installations.
This talk will present the PostgreSQL replication solutions pglogical 3 and BDR 3.
pglogical is a PostgreSQL extension for logical replication between two nodes. Most of the code for built-in logical replication in PostgreSQL 10 was derived from pglogical, while pglogical offers a larger feature set, such as row and column filtering, conflict resolution, and compatibility back to PostgreSQL...