Vacuum settings for mostly append-only data
2
votes
3
answers
2231
views
I have a table with the following characteristics:
1. We INSERT a few 100k rows each day
2. We never UPDATE the rows
3. We DELETE "old" data once a week
From my shallow knowledge of Postgres VACUUM, it seems like this table might be a good candidate for a non-standard VACUUM strategy. A few questions I have...
1. Apart from the weekly purging of old data, will a VACUUM _do_ anything? Seems to me there is nothing to compact/clean if we're only doing INSERTs.
2. Would it be a horrible idea to simply disable AUTOVACUUM on that table and manually VACUUM FULL after our weekly DELETE?
Asked by Larsenal
(123 rep)
Aug 13, 2013, 06:41 PM
Last activity: Aug 14, 2013, 01:18 AM
Last activity: Aug 14, 2013, 01:18 AM