Schedule - FOSDEM PGDay 2024

Build Your Own PostgreSQL DBA Out Of Available MySQL DBAs

Date: 2024-02-04
Time: 16:00–16:50
Room: PostgreSQL Devroom

Historically it has been able to find MySQL DBAs than their PostgreSQL counterparts. The growth in PostgreSQL has increased the demand for new DBAs. So why not convert some MySQL DBAs into competent PostgreSQL DBAs?

This session covers where you need to concentrate on guiding this conversion. There are many similarities between the two RDMS but this session covers where the 'pinch points' are that will require guidance. Starting with setting up a basic instance for the conversion candidates with a familiar-ish training database, we will proceed into differences in MVCC, Indexing, TOAST, and other divergent areas.

You can very quickly have a new PostgreSQL DBA that you have built yourself.

Slides

The following slides have been made available for this session:

Speaker

Dave Stokes