On 06/26/11 2:23 PM, Dave Coventry wrote:
While the server is a little challenged in the way of RAM, it is by no means under any sort of load.
I didn't read the whole thread, but is this a Linux server? Linux has a horrible feature, the "Out of Memory Killer", which kills off processes when the system is low on memory.
the OOM-Killer usually leaves log entries in DMESG and maybe /var/log/messages
If in fact its the OOM killer, you should probably lower your WORK_MEM and SHARED_BUFFERS and maybe MAINTENANCE_WORK_MEM in postgresql.conf
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general