
Memory
Postgres FM
How to Set Maintenance Work Mam to Minus Zero
octo vacuum work mam is set to minus zero meaning that it's inherited from maintenance work mam. By default auto vacuum workmam is minus one by default and most cases i see people don't touch it so it means both about index creation and patience such operations like index creation or indexing and also auto vacuuming. Usually you want to raise it at least like one gigabyte if you have a lot of memory or half of gigabyte but interesting i made a couple of years ago i made new experiments uh trying to understand how beneficial it is to go to higher values.
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.