Queues in Postgres
Postgres FM
00:00
How to Use Auto Vacuum to Catch Up With Default Settings
In this case, definitely we will have right amplification. All indexes that the table has will need to receive these rights. Even if that's an index column, that's cool. If auto vacuum deletes that apples not in the end of table, it cannot truncate this page,. It will keep, maybe whole page will be empty sitting there, just contributing to bloat. That's why the name, actually, a right of notification. And all these rights will go to wall. It will go to backups. It'll go to replication. But even if I'm right, in some cases, we still won't have hot update.
Transcript
Play full episode
