Vacuum analyze only unprocessed, modified tables in maintenance

metadb-project / metadb

Metadb extends PostgreSQL with features to support analytics such as streaming data sources, data model transforms, and historical data

Apache License 2.0

8 stars 2 forks source link

Closed nassibnassar closed 11 months ago

nassibnassar commented 1 year ago

Improve maintenance phase of vacuum analyze:

Avoid reprocessing recently processed tables.
Avoid processing tables not recently updated (requires a new cache of timestamped last change which is periodically flushed, possibly to metadb.table_update).