PostgreSQL Partitioning: Beyond the obvious
Presented by:
Chirag Dave
Chirag Dave is a Principal Database Specialist Solutions Architect with Amazon Web Services. he maintains technical relationship with customers, making recommendations on security, cost, performance, reliability, operational efficiency and best-practice architectures.
Sami Imseih
No video of the event yet, sorry!
Partitioning divides table into smaller parts which helps in improving database performance and scalability. In PostgreSQL there not so obvious reason why you want to partition your table effectively to improve scalability, optimize the performance and management of your database.
In this talk we will discuss Vacuuming, caching benefits, and multi-tenancy with respect to partitioning. You will also learn about partitioning anti-patterns and tips and tricks for partitioning management.
- Date:
- 2024 April 19 10:00 PDT
- Duration:
- 50 min
- Room:
- Santa Clara
- Conference:
- Postgres Conference 2024
- Language:
- English
- Track:
- Essentials
- Difficulty:
- Intermediate