Loading…
Back To Schedule
Tuesday, October 20 • 23:30 - Wednesday, October 21 •00:00
PostgreSQL WAL and Commit Synchronization, Optimization Opportunities

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.


PostgreSQL uses different types of WAL records for recording activities happening on the database. A deeper understanding of what they are, how they are synchronized, what the optimization opportunities are, etc., can lead to a better-tuned system.

This talk also discusses the different sets of PostgreSQL parameters and their impact on WAL and optimization considerations for a high-performance database.

This talk covers:
  1. What the WAL records are
  2. Synchronization considerations
  3. What is important from the host IO subsystem
  4. Parameters for tuning
  5. Different levels of tuning, Instance, Database, User, Session, and Transaction,
    and how it impacts performance.
  6. WAL Propagation to standby
  7. Synchronous standby, important points to be considered
  8. Remote write, flush, and replay stages.
This talk also includes small code snippets, demonstrations, and efficiency comparisons.

Speakers
avatar for Jobin Augustine

Jobin Augustine

PostgreSQL Escalation Specialist, Percona
Jobin Augustine is a PostgreSQL expert and Open Source advocate and has more than 19 years of working experience as consultant, architect, administrator, writer, and trainer in PostgreSQL, Oracle and other database technologies. He has always been an active participant in the Open... Read More →

Hosts
avatar for Mukesh Kumar

Mukesh Kumar

MongoDB DBA, Percona



Tuesday October 20, 2020 23:30 - Wednesday October 21, 2020 00:00 EDT
Online
  PostgreSQL
  • Difficulty Advanced
  • Why this level of difficulty? This talk can be beneficial to Intermediate as well as advanced users.
  • Speaker Location India