1. 背景介绍
当前运行的设备中,安装了一个PG V15版本的数据库,且该数据库正常运行。此环境中,有一个SQ脚本,该脚步文件的SQL语句较多,约在8K ~ 1W+行。
1.1 报错信息
此脚本运行后,隔一段时间收到了:
2023-09-15 14:30:51.535 GMT [57678] DEBUG: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-09-15 14:30:51.545 GMT [93717] DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2023-09-15 14:30:51.545 GMT [93717] DEBUG: ternary: vac: 0 (threshold 20000064), ins: 0 (threshold 20001014), anl: 0 (threshold 10000057)
2023-09-15 14:30:51.545 GMT [93717] DEBUG: pg_statistic: vac: 0 (threshold 130), ins: 3 (threshold 1080), anl: 3 (threshold 90)
2023-09-15 14:30:51.545 GMT [93717] DEBUG: pg_type: vac: 0 (threshold 132), ins: 3 (threshold 1082), anl: 3 (threshold 91)
2023-09-15 14:30:51.545 GMT [93717] DEBUG: pg_authid: vac: 0 (threshold 52), ins: 0 (thresh