<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div style="color: rgb(0, 0, 0); font-family: verdana, geneva; font-size: 10pt;">Good Morning,</div><div style="color: rgb(0, 0, 0); font-family: verdana, geneva; font-size: 10pt;"><br></div><div style="color: rgb(0, 0, 0); font-family: verdana, geneva; font-size: 10pt;">I'm repeatedly getting a session killed error while trying to run a series of queries:</div><div style="color: rgb(0, 0, 0); font-family: verdana, geneva; font-size: 10pt;"><br></div><div><font face="verdana, geneva"><span>/opt/postgres/9.1/bin/psql: line 30: 5560 Killed LD_PRELOAD=$PLL LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PG_BIN_PATH/../lib "$PG_BIN_PATH/psql.bin" "$@"</span></font></div><div><font face="verdana, geneva"><span>/opt/postgres/9.1/bin/psql: line 30: 5701 Killed LD_PRELOAD=$PLL LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PG_BIN_PATH/../lib "$PG_BIN_PATH/psql.bin" "$@"</span></font></div><div><font face="verdana, geneva"><span>/opt/postgres/9.1/bin/psql: line 30: 5781 Killed LD_PRELOAD=$PLL LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PG_BIN_PATH/../lib "$PG_BIN_PATH/psql.bin" "$@"</span></font></div><div style=""><br></div><div style=""><br></div><div style="">I'm not seeing a whole lot about this error online. Has anyone else run into this issue? I'm thinking it is a memory problem but am not sure. I'm not the system administrator, just the dba.</div><div style=""><br></div><div style="">Here's a vmstat run:</div><div style=""><br></div><div style=""><div>[postgres(at)vmdb05-qa dump]$ vmstat 10 5</div><div>procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----</div><div> r b swpd free buff cache si so bi bo in cs us sy id wa st</div><div> 1 1 458008 167648 6280 7208016 0 0 330 271 1 1 1 0 97 2 0</div><div> 0 1 458008 148304 6272 7227352 0 0 22074 139 1029 1657 4 1 50 45 0</div><div> 0 1 458008 147548 5996 7228640 0 0 21304 141 986 1543 5 1 50 44 0</div><div> 0 1 458008 165776 5984 7210004 0 0 19110 138 892 1389 4 1 50 45 0</div><div> 0 1 458008 130808 5992 7245164 0 0 12104 138 575 996 2 1 50 47 0</div></div><div><br></div><div>Top stats:</div><div><br></div><div><div>top - 08:54:11 up 270 days, 19:42, 3 users, load average: 1.00, 0.95, 0.59</div><div>Tasks: 240 total, 1 running, 239 sleeping, 0 stopped, 0 zombie</div><div>Cpu(s): 1.2%us, 0.2%sy, 0.0%ni, 97.1%id, 1.5%wa, 0.0%hi, 0.0%si, 0.0%st</div><div>Mem: 8062088k total, 7918524k used, 143564k free, 6184k buffers</div><div>Swap: 2047992k total, 457864k used, 1590128k free, 7159444k cached</div></div><div style=""><br></div><div style=""><br></div><div style=""><br></div><div style="">Here are some configuration details:</div><div style=""><br></div><div style=""><div>The PostgreSQL version is 9.1.9. The server is Red Hat Enterprise Linux Server release 6.2 (Santiago) on a VM machine - 8 GB RAM with 2 CPUs:</div><div><br></div><div style=""><div><font face="courier new, monospace">Architecture: x86_64</font></div><div><font face="courier new, monospace">CPU op-mode(s): 32-bit, 64-bit</font></div><div><font face="courier new, monospace">Byte Order: Little Endian</font></div><div><font face="courier new, monospace">CPU(s): 2</font></div><div><font face="courier new, monospace">On-line CPU(s) list: 0,1</font></div><div><font face="courier new, monospace">Thread(s) per core: 1</font></div><div><font face="courier new, monospace">Core(s) per socket: 2</font></div><div><font face="courier new, monospace">CPU socket(s): 1</font></div><div><font face="courier new, monospace">NUMA node(s): 1</font></div><div><font face="courier new, monospace">Vendor ID: GenuineIntel</font></div><div><font face="courier new, monospace">CPU family: 6</font></div><div><font face="courier new, monospace">Model: 44</font></div><div><font face="courier new, monospace">Stepping: 2</font></div><div><font face="courier new, monospace">CPU MHz: 2660.000</font></div><div><font face="courier new, monospace">BogoMIPS: 5320.00</font></div><div><font face="courier new, monospace">L1d cache: 32K</font></div><div><font face="courier new, monospace">L1i cache: 32K</font></div><div><font face="courier new, monospace">L2 cache: 256K</font></div><div><font face="courier new, monospace">L3 cache: 12288K</font></div><div style=""><font face="courier new, monospace" style="">NUMA node0 CPU(s): 0,1</font></div><div style=""><font face="courier new, monospace" style=""><br></font></div><div style=""><font face="courier new, monospace" style="">Thanks,</font></div><div style=""><font face="courier new, monospace" style=""><br></font></div><div style=""><font face="courier new, monospace" style="">Johnh</font></div></div></div></span></body></html>