-
由 盏一 提交于
The basic idea for only enabling auto-ANALYZE through Master’s autovacuum daemon is to collect pgstat info into Master when executing queries. Start the Master’s autovacuum launcher process. Fire an autovacuum work process for a database on Master when the naptime reaches. Then the autovacuum worker will iterate through all tables/materialized views under a specified database, and execute ANALYZE for tables which reached the analyze threshold. Note the ANALYZE statement issued in the autovacuum worker on Master is the same as executing it through query on QD. ie. The auto-ANALYZE is coordinated by the master and segments do not start it’s own autovacuum launcher and autovacuum worker. More details please refer to src/backend/postmaster/README.auto-ANALYZE. Co-authored-by: NJunfeng(Jerome) Yang <jeyang@pivotal.io>
0b17968e