PostgreSQL (Structured Query Language) dynamic transferable table space method based on storage and calculation separation architecture

The invention discloses a PostgreSQL (Structured Query Language) dynamic transferable table space method based on a storage and calculation separation architecture. The method comprises the following steps: monitoring that a PostgreSQL database is subjected to data updating, copying an original data line to a table space, generating a new version data line by data updating, and storing an Undo pointer at the line header of the new version data line; in response to transaction rollback of the PostgreSQL database, copying the original data row from the table space to the original place; in response to the situation that all sessions do not need to access the original data rows of the table space any more, the original data rows are cleaned, and the table space is released; the configuration table space Async Freeze algorithm solution is used for solving the phenomenon that XID value domain coincidence is unavailable. 本发明公开了一种基于存算分离架构的PostgreSQL动态可转移表空间方法，其包括监测到PostgreSQL数据库发生数据更新，将所述原始数据行拷贝到表空间，数据更新产生新版本数据行，于所述