Trigger control method and system of autovacuum

The invention relates to a trigger control method and a trigger control system for an autosuum. The method comprises the following steps: S1, acquiring and calculating a table in which transaction numbers are recorded, and the age increase in a set period; s2, obtaining and calculating the table siz...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: XING YINGXIN, HUANG QIUZI, SHI RUI, CAO YINGJIAN, CHEN TIANXIN, QIAN CHENG, WANG KE
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention relates to a trigger control method and a trigger control system for an autosuum. The method comprises the following steps: S1, acquiring and calculating a table in which transaction numbers are recorded, and the age increase in a set period; s2, obtaining and calculating the table size of a business table in the database, obtaining an active tuple and a dead tuple of the business table, and calculating the size of wal generated in the process of cleaning the table by combining the size of the business table, the active tuple and the dead tuple; s3, according to the age of a table pgclass recorded in the plaardb, the business tables recorded by the pgclass are batched, and in combination with the calculation results of S1 and S2, the table size of the business tables needing to be subjected to autosuum processing and the size of wal generated by autosuum in a future set period are estimated; and S4, calculating a business table which needs to be scheduled to a low peak period for artificial vacu