-=vyruss=- / blog

  • articles
  • talks
  • tweets
  • blog roll
  • main page

Practical Partitioning in Production with Postgres [Postgres Vision 2021]

  • Jun 26, 2021
  • 1 min read
  • Categories: talks
  • Tags: #postgresql #postgresvision #dba

Has your table become too large to handle? Have you thought about chopping it up into smaller pieces that are easier to query and maintain? What if it's in constant use?

An introduction to the problems that can arise and how PostgreSQL's partitioning features can help, followed by a real-world scenario of partitioning an existing huge table on a live system.

Video from my talk at this year's Postgres Vision 👇

You can find the slides from the talk here.

Sat 26 Jun 2021 08:17:38
Wed 23 Jun 2021 14:15:00
Rendering: Pelican  •  Theme: Peli-Kiera (modified)  •  Copyright © 2025   Jimmy Angelakos