Reducing Costs and Improving Performance With Data Modeling in Postgres
Presented by:
Charly Batista
Charly is the PostgreSQL Tech Lead at Percona and is passionate about databases and performance. He has been working with databases and development for over 20 years and has participated in many projects, from the design of a small sensor to count how many times a ball passes through a basketball hoop to complex database proxy applications.
Outside work, he loves sports, as a good Brazilian he practices football (or soccer), volleyball, and surprisingly ping-pong. Charly is also passionate about new cultures, their languages, and traditions, and has lived and/or worked in a few different countries. Today he basically lives between Brazil and China. Not really in between, but stays some time in Brazil and some time in China :D
In this session we'll unravel the intricacies of PostgreSQL's internal data organisation, shedding light on the Free Space Map (FSM) mechanism. Delving into the heart of PostgreSQL's data architecture, we'll explore ways to strategically reorganise the data model, capitalising on data alignment within blocks. The goal? To unveil techniques that not only optimise disk space usage but also enhance memory efficiency, potentially leading to significant cost savings and performance improvements.
Discover the art of aligning data inside blocks, a crucial facet often overlooked in PostgreSQL optimisation. By strategically aligning data, we can wield the power to reduce the footprint of stored information on both disk and memory. As we navigate through practical examples and insightful strategies, you'll gain a newfound understanding of how these optimisations directly impact your budgetary considerations and system performance.
- Date:
- 2024 April 17 15:10 PDT
- Duration:
- 50 min
- Room:
- Santa Clara
- Conference:
- Postgres Conference 2024
- Language:
- English
- Track:
- Essentials
- Difficulty:
- Intermediate