Comment Comment by menthe False.As of PG16, HOT updates are tolerated against summarizing indexes, such as BRIN.https://www.postgresql.org/docs/16/storage-hot.htmlBesides, you probably don't want "done" jobs in the same table as pending or retriable jobs - as you scale up, you likely want to archive them as it provides various operational advantages, at no cost. parent menthe 1 year ago
As of PG16, HOT updates are tolerated against summarizing indexes, such as BRIN.
https://www.postgresql.org/docs/16/storage-hot.html
Besides, you probably don't want "done" jobs in the same table as pending or retriable jobs - as you scale up, you likely want to archive them as it provides various operational advantages, at no cost.