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!
|
| container_end_page | |
|---|---|
| container_issue | |
| container_start_page | |
| container_title | |
| container_volume | |
| creator | XING YINGXIN HUANG QIUZI SHI RUI CAO YINGJIAN CHEN TIANXIN QIAN CHENG WANG KE |
| description | 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 |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN116521327A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN116521327A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN116521327A3</originalsourceid><addsrcrecordid>eNrjZNAPKcpMT08tUkjOzyspys9RyE0tychPUUjMS1EoriwuSc1VyE9TSCwtyS9LTC4tzeVhYE1LzClO5YXS3AyKbq4hzh66qQX58anFBYnJqXmpJfHOfoaGZqZGhsZG5o7GxKgBAEMBKxs</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Trigger control method and system of autovacuum</title><source>esp@cenet</source><creator>XING YINGXIN ; HUANG QIUZI ; SHI RUI ; CAO YINGJIAN ; CHEN TIANXIN ; QIAN CHENG ; WANG KE</creator><creatorcontrib>XING YINGXIN ; HUANG QIUZI ; SHI RUI ; CAO YINGJIAN ; CHEN TIANXIN ; QIAN CHENG ; WANG KE</creatorcontrib><description>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</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2023</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20230801&DB=EPODOC&CC=CN&NR=116521327A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76290</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20230801&DB=EPODOC&CC=CN&NR=116521327A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>XING YINGXIN</creatorcontrib><creatorcontrib>HUANG QIUZI</creatorcontrib><creatorcontrib>SHI RUI</creatorcontrib><creatorcontrib>CAO YINGJIAN</creatorcontrib><creatorcontrib>CHEN TIANXIN</creatorcontrib><creatorcontrib>QIAN CHENG</creatorcontrib><creatorcontrib>WANG KE</creatorcontrib><title>Trigger control method and system of autovacuum</title><description>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</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2023</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZNAPKcpMT08tUkjOzyspys9RyE0tychPUUjMS1EoriwuSc1VyE9TSCwtyS9LTC4tzeVhYE1LzClO5YXS3AyKbq4hzh66qQX58anFBYnJqXmpJfHOfoaGZqZGhsZG5o7GxKgBAEMBKxs</recordid><startdate>20230801</startdate><enddate>20230801</enddate><creator>XING YINGXIN</creator><creator>HUANG QIUZI</creator><creator>SHI RUI</creator><creator>CAO YINGJIAN</creator><creator>CHEN TIANXIN</creator><creator>QIAN CHENG</creator><creator>WANG KE</creator><scope>EVB</scope></search><sort><creationdate>20230801</creationdate><title>Trigger control method and system of autovacuum</title><author>XING YINGXIN ; HUANG QIUZI ; SHI RUI ; CAO YINGJIAN ; CHEN TIANXIN ; QIAN CHENG ; WANG KE</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN116521327A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2023</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>XING YINGXIN</creatorcontrib><creatorcontrib>HUANG QIUZI</creatorcontrib><creatorcontrib>SHI RUI</creatorcontrib><creatorcontrib>CAO YINGJIAN</creatorcontrib><creatorcontrib>CHEN TIANXIN</creatorcontrib><creatorcontrib>QIAN CHENG</creatorcontrib><creatorcontrib>WANG KE</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>XING YINGXIN</au><au>HUANG QIUZI</au><au>SHI RUI</au><au>CAO YINGJIAN</au><au>CHEN TIANXIN</au><au>QIAN CHENG</au><au>WANG KE</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Trigger control method and system of autovacuum</title><date>2023-08-01</date><risdate>2023</risdate><abstract>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</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | chi ; eng |
| recordid | cdi_epo_espacenet_CN116521327A |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | Trigger control method and system of autovacuum |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-01T08%3A22%3A30IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=XING%20YINGXIN&rft.date=2023-08-01&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN116521327A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true |