Does anyone know what autovacuum means in the sense of databases?
+1
A:
Specific to PostgreSQL it means:
PostgreSQL's VACUUM command has to run on a regular basis for several reasons:
1.To recover or reuse disk space occupied by updated or deleted rows.
2.To update data statistics used by the PostgreSQL query planner.
3.To protect against loss of very old data due to transaction ID wraparound.
Mitch Wheat
2010-07-11 09:05:59
+1
A:
On Google App Engine this refers to the Indexes (you vacuum an index, meaning you remove it).
On Postgre it refers to tidying up the database table (garbage collection and optimisation).
An autovacuum daemon waits until there are no transactions and then dives in to perform the vacuum operation.
Metalshark
2010-07-11 09:06:12
+1
A:
In postgres the AUTOVACUUM refers to regular maintenance tasks:
- To recover disk space occupied by updated or deleted rows.
- To update data statistics used by the PostgreSQL query planner.
- To protect against loss of very old data due to transaction ID wraparound.
See: http://www.postgresql.org/docs/8.1/static/maintenance.html
The MYYN
2010-07-11 09:06:29