Postgresql9.1.6在大量進行insert和空間查詢時 內(nèi)存溢出的問題

letheanwater

目前是這樣的，要做一個網(wǎng)絡(luò)分析。所以會有大量的空間查詢和insert操作進行。
發(fā)現(xiàn)在大量操作時，會導(dǎo)致系統(tǒng)內(nèi)存溢出，進而數(shù)據(jù)庫的progress就crash了。無法再連。
下面是截取的日志，這個上面是大量的SPI TupTable這樣的語句，非常多。

      SPI TupTable: 8192 total in 1 blocks; 6824 free (0 chunks); 1368 used
      SPI TupTable: 8192 total in 1 blocks; 6824 free (0 chunks); 1368 used
      SPI TupTable: 8192 total in 1 blocks; 6824 free (0 chunks); 1368 used
  MessageContext: 24576 total in 2 blocks; 19128 free (6 chunks); 5448 used
  Operator class cache: 8192 total in 1 blocks; 4872 free (0 chunks); 3320 used
  smgr relation table: 8192 total in 1 blocks; 760 free (0 chunks); 7432 used
  TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks); 16 used
  Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
  PortalMemory: 8192 total in 1 blocks; 7768 free (1 chunks); 424 used
    PortalHeapMemory: 7168 total in 3 blocks; 1640 free (0 chunks); 5528 used
      ExecutorState: 32832 total in 3 blocks; 5384 free (1 chunks); 27448 used
LOG:  server process (PID 11452) was terminated by exception 0xC0000005
HINT:  See C include file "ntstatus.h" for a description of the hexadecimal value.
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and e
xit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and e
xit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted; last known up at 2014-07-17 13:46:05 HKT
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 1/D104A18
LOG:  record with zero length at 1/D10C980
LOG:  redo done at 1/D10C940
LOG:  last completed transaction was at log time 2014-07-17 13:57:03.486+08
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started


還請大家不吝賜教啊。

asdf2110

報一下具體啊
操作系統(tǒng)版本，內(nèi)存大小，cpu核數(shù)，數(shù)據(jù)量大小，數(shù)據(jù)庫shared_buffers, work_mem 等等

回復(fù) 1# letheanwater


   

pg2pg

肯定你用了C語言寫的擴展，而那個擴展里面有bug，從異�？磻�(yīng)該是訪問非法內(nèi)存位置。