Dave Pitts

This introductory talk for DEVs and DevOps will focus on * Why you’re likely to be working with both B-trees and LSM-trees in the future * Key differences between B-trees and LSM-trees, and surprising gotchas when switching workloads between them

Understanding all the details of a High Availability PostgreSQL clusters is one of the most critical DBA knowledge area's. Instead of boring you with endless numbers of slides, with volunteer assistance from the audience, we will show you all important concepts like WAL transport, synch/async commit, RTO, RPO, network involvement etc with nothing more than a few decks of playing cards and some...

Postgres WORK_MEM is an important parameter to control the private memory allocated to the worker process but is not that often discussed in-depth at pgconf / pgday events.

At Adyen we have invested heavily and built upon the Postgres database engine, generally this has worked very well for us. Occasionally Postgres Write Amplification can be technical challenge at Adyen, fortunately this does not happen often, unfortunately when it does happen it is around critical, high volume workloads.