Robert Bernier
Senior PostgreSQL Consultant at Percona
Robert's experience extends several decades. His first experience was playing hangman on a DECwriter shortly after man first landed on the moon. His foray into commercial applications was programming Fortran, via punchcards, on an IBM 360 which in those days had 4MB RAM. Over the ensuing years he progressed into the first generation of workstations among which included the IBM 8080 XT, and AT. Robert discovered Linux and the opensource world in the 90s. By the early 2000s his primary focus had become all things PostgreSQL and has since then worked in various sized companies both small and large including Fortune 50 companies.
Robert is the Senior PostgreSQL Consultant at Percona. In his spare time he enjoys all things nature including hiking, camping, canoing and trying not to fall off the side of mountains here in the Pacific Northwest.
Upcoming presentations
Vector Database Performance Challenges, A CaseStudy
Working With The pg_vector And pg_vectorscale Indexes
AI brings vector data types to our attention like lightening warns us of the impending thunderclap in a storm. And like thunder, we don't know what it means until its too late. Despite the rapid advances developing pg_vector, an improperly designed system is more than likely to occur resulting in slow performance.
This case-study is based upon the challenges developing a solution manipulatin...
Implementing Transparent Data Encryption At Rest
HowTo Master pg_tde
The very last line of defense against protecting your data from theft or exploitation is securing the appliance that holds it. In the past, protecting your data at rest in PostgreSQL relied upon the filesystem encryption used on the persistant storage. This session will introduce you to the freely available opensource extension pg_tde. W'ell review basic concepts, and how easy it is to install ...
Past presentations
You may have worked with Patroni and even CitusDB but have you ever worked with them together? This session will go through the steps of creating a CitusDB architecture that will have all the automated disaster recovery capabilities that you have come to love and expect from a standard replication cluster managed by Patroni.
This talk outlines and demonstrates several opportunistic methods scaling your PostgreSQL replication cluster across multiple regions. Each architecture is presented as as POC profiling its particular strengths and of course weaknesses. It is hoped that by demonstrating these variations an appropriate architecture can be created that can best meet any long term objectives over its life-cycle.
Nov 6 2024
Working With The Citus Extension
A Gentle Introduction
Scaling PostgreSQL is a big deal but it doesn't have to be hard. There was a time when the only way scaling PostgreSQL was to design the architecture entirely on your own and basically figure out the entire life-cycle before even putting it into production. Since those early days a lot of technologies and processes have come into being that can guide one to creating, growing and maintaining a ...
Apr 19 2024