An ai intelligent agent memory management method and device based on a postgresql database

Abstract

This application relates to the field of database technology and discloses an AI intelligent agent memory management method and device based on a PostgreSQL database. The method includes: upon receiving a memory change request, creating a new record in the memory table containing a current validity flag and version chain information through a database transaction; continuously capturing data changes in the memory table using logical replication slots to obtain change events; parsing the change events through an independent consumer service to generate structured information and persistently storing the structured information in an audit log table; exporting a specified transaction snapshot identifier from a relational database when the AI ​​intelligent agent starts executing a specified task; importing the specified transaction snapshot identifier into a new database transaction whenever the AI ​​intelligent agent needs to query the memory during the execution of the specified task; and performing backtracking and / or rollback operations on the memory state based on the version chain information in the audit log table and / or the memory table.

Images