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
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)