HOT - Understanding This Important Update Optimization

Wednesday 5:00 PM - 5:25 PM

@ Wallstreet 2

PostgreSQL

25 minutes conference

Intermediate

Tracks:
Case Studies/Use cases, Developer

In this session, we will dive deep into HOT (Heap Only Tuple) update optimization. Utilizing this optimization can result in improved writes rates, less index bloat and reduced vacuum effort but to enable PostgreSQL to use this optimization may require changing your application design and database settings. We will examine how the number of indexes, frequency of updates, fill factor and vacuum settings can influence when HOT will be utilized and what benefits you may be able to gain.


Speakers

Jim Mlodgenski

Jim Mlodgenski (Amazon Web Services)

Principal Engineer

Biography:

Principal database engineer at Amazon Web Services, Co-Chair - PGConf US, Director - United States PostgreSQL, Co-organizer of Philly PUG & NYC PUG, former CTO at OpenSCG


Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863