Loading…
Attending this event?
Welcome to Percona Live Online 2021
Online Open Source Database Conference
REGISTER HERE!
Back To Schedule
Thursday, May 13 • 13:30 - 14:00
Implementing Efficient Checkpointing in PostgreSQL

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Video will become available 10 minutes before session start


Checkpointing is one of the main issues in PostgreSQL which determines the impact of write/read performance because it involves a lot of processing by the CPU. Assuming the database server is hosted on a node/machine with just a CPU(but with no separate I/O processor). If checkpointing is not tuned well, it makes the CPU very busy than usual. Thus it affects read/write performance of database server since the processor is mostly focused on transferring dirty buffers from memory to the data files on disk. Understanding your application and database infrastructure helps in tuning checkpointing well.

Speakers
avatar for Michael Aboagye

Michael Aboagye

Postgresql Consultant, Vettabase
Michael is a postgresql consultant at Vettabase Ltd and also works as a freelance data/systems engineer solving hard problems for startups all over the world. He lives in Accra, Ghana.


Thursday May 13, 2021 13:30 - 14:00 EDT
Room #1
Feedback form isn't open yet.