Automatic table partitioning method of PG database and related device

The invention discloses an automatic table partitioning method for a PG database. The method comprises the steps of obtaining a PG database partitioning instruction; obtaining a version number of thePG database according to the PG database partitioning instruction; when the version number is lower t...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: SUN ZHIYUN
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 discloses an automatic table partitioning method for a PG database. The method comprises the steps of obtaining a PG database partitioning instruction; obtaining a version number of thePG database according to the PG database partitioning instruction; when the version number is lower than V10, downloading and installing a pathman plug-in; calling the pathman plug-in to carry out table partitioning on the PG database; and when the version number is not lower than V10, performing table partitioning on the PG database through a preset partitioning function module of the PG database. When the version of the PG database is lower than V10, the pathman plug-in is automatically downloaded and installed, and table partitioning of the PG database is completed based on the pathman plug-in; and when the version of the PG database is not lower than V10, table partitioning of the PG database is completed based on a partition function module of the PG database. The invention further provides a device, equipmen