Presented by:

Robert Bernier

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.

No video of the event yet, sorry!

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 horizontally scaled postgres network cluster that can grow into the peta-bytes.

This talk is about one of those new technologies, enter Citus.

Initially created as a start up in the Bay Area the citus extension can easily be added to several postgres standalone servers and joining them to form a single cohesive cluster.

This talk will cover:

  • where to get it
  • how to install it
  • it's basic feature set
  • an example walk-thru developing and growing a cluster using pgbench
  • caveats: what to keep in mind

Date:
2024 April 19 09:00 PDT
Duration:
50 min
Room:
Winchester
Conference:
Postgres Conference 2024
Language:
English
Track:
Ops
Difficulty:
Intermediate