High Performance pgBackRest (Charm City PostgreSQL Meetup 2020)
pgBackRest is open source software developed to perform efficient backup on PostgreSQL databases that measure in tens or hundreds of terabytes and/or generate high WAL volume. pgBackRest supports a robust set of performance features, including: parallel backup/restore, delta restore, parallel asynchronous archiving, partial/failed backup resume, backup from standby, and more.
This talk by the primary maintainer will focus on:
- Performance features of pgBackRest.
- Practical configuration examples.
- Parallel backup/restore and archiving implementations.
The attendee should gain a good understanding of which performance features are useful in a variety of circumstances.
Bio:
David Steele is Principal Architect at Crunchy Data, the Trusted Open Source Enterprise PostgreSQL Leader. He has been actively developing with PostgreSQL since 1999.
David loves taking on big data challenges. Until recently he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.
David's current project is pgBackRest, which will be the subject of this talk.