我正在使用PostgreSQL 8.4和PostGIS 1.5,想要做的是从一个表中将数据插入到另一个表中(但不完全相同)。对于每一列,都会运行一些查询,并且共有50143行存储在该表中。但是查询非常耗费资源:查询运行几分钟后,连接就会断开。这通常会在查询执行21-22k MS后发生,然后我必须手动重新启动数据库管理系统。我应该如何解决这个问题?
错误信息如下:
此外,这是psql错误日志:
错误信息如下:
[Err] server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
此外,这是psql错误日志:
2013-07-03 05:33:06 AZOST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-07-03 05:33:06 AZOST WARNING: terminating connection because of crash of another server process
2013-07-03 05:33:06 AZOST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.