PostgreSQL的vacuum过程中heap_vacuum_rel函数分析

PostgreSQLvacuumheap_vacuum_relPostgreSQLvacuumheap_vacuum_relPostgreSQLvacuumheap_vacuum_relPostgreSQLvacuum,ExecVacuum->vacuum->vacuum_rel->heap_vacuum_rel
VacuumAnalyzeVacuumStmt
vacuumoption&RelationVacuumParams
vacuumVacuumRelation
VACUUM/ANALYZEBu免费云主机域名fferAccessStrategy
BufferLVRelStatsPGRUsage
pg_rusage_init/pg_rusage_showheap_vacuum_rel() heap relationVACUUM
:
1.,//
2.vacuum_set_xid_limitsxmin
3.(pages),aggressive
4.vacrelstats
5.,lazy_scan_heapvacuuming,
6.pg_class
7.gdb,
:PGheap_vacuum_rel,PG 11.1lazy_vacuum_rel
relationvacuumbuffer1.,//2.vacuum_set_xid_limitsxmin
,OldestXminID3.(pages),aggressive,F4.vacrelstats5.,lazy_scan_heapvacuuming,6.pg_class7.PostgreSQLvacuumheap_vacuum_rel

相关推荐: oracle后台进程LGWR,DBWR,SMON,CKPT的工作机制

在出现以下情况时LGWR会开始工作： SMON进程的工作归纳如下: CKPT检查点进程的作用是执行一个检查点，同步数据库的所有数据文件，控制文件和重做日志文件。当执行检察点时，系统促使DBWn将数据缓存区中数据的变化写入数据文件，同时完成对数据文件和控制文件的…