HOT updates | Postgres.FM 020 | #PostgreSQL #Postgres podcast

Michael and Nikolay discuss Heap-Only Tuple (HOT) updates — what they are, the benefits, and things you can do to optimize for them.

Here are links to a few things we mentioned:

-------------

~~~
Postgres FM is brought to you by:
- Michael Christofides, founder of pgMustard

~~~

[jlowe_n]

Do Foreign Keys have any impact on Update performance? For example, if we have a table (PK integer, display name, url, uuid, created_timestamp, updated_timestamp, archive flag, meta - indexes on everything except archive flag and meta JSON) that contains a general record for most other tables and the PK integer is the FK for many other tables. Would splitting off an oft-updated index into a separate table mitigate the impact of Cold Updates to a heavily indexed table? Awesome information here!

[NikolaySamokhvalov]

I was terribly wrong saying that DELETE modifies all indexes - of course it doesn’t (if we don’t consider subsequent async activity from vacuums). Will need to correct my self next time.