Sample Header Ad - 728x90

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