Reducing Costs and Improving Performance With Data Modeling in Postgres
Understanding how PostgreSQL organizes the data internally can save costs!
Presented by:
Charly Batista
Percona LLC
A Brazilian living in China... Charly is passionate about new cultures, their languages and traditions. Charly has been working with database and development for more than 12 years and has participated in small and large projects in Brazil, the US, China and other countries.
During this talk we will explain how PostgreSQL organizes the data internally, how the Free Space Map (FSM) works and how we can reorganize the data model to take advantage of data alignment inside blocks reducing the size of the data in disk and consequently in memory, which can save money and improve performance.
- Date:
- 2021 October 6 13:00 EDT
- Duration:
- 1 h
- Room:
- Online
- Conference:
- 2021 Postgres Conference Webinars
- Language:
- Track:
- Ops
- Difficulty:
- Medium
- Requires Registration:
- Yes (Registered: 126)