3 ms·
what does as often as possible mean? It will auto-vacuum when it's idle, right? Why not just let it do that?
by TurdF3rguson 4mo ago
what does as often as possible mean? It will auto-vacuum when it's idle, right? Why not just let it do that?
- baq 4mo agoWhat do you mean by ‘idle’? If you mean your database is seeing extended periods of no updates to a table, you still want to vacuum, maybe even vacuum full if you know when traffic stopped and for how long to get the best possible read performance. If you have quiet periods in both reads and writes, enjoy the luxury of having an unused database to operate.