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...
Gespeichert in:
Hauptverfasser: | , , , , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
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 |
---|