Postgres FM cover image

Memory

Postgres FM

CHAPTER

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.
App store bannerPlay store banner