On Thu, 27 Jul 2006, Daniel Caune wrote:
Actually ulimit is unlimited for user postgres and when the server was terminated the memory used was not that much compared to the machine capacity:
Mem: 2075860k total, 1663520k used, 412340k free, 5620k buffers
Swap: 369452k total, 0k used, 369452k free, 1626176k cached
I feel a bit lost, because it was running pretty well for the last couple months. This table is a data stage table where some data are imported in from OLTP databases, this every day. Indexes are dropped before inserting data and created when insertion has finished. The structure didn't change since a while.
Daniel,
Was this 'free' output before or after the crash? Also, have you combed
through /var/log/messages for anything interesting that happened around the
time of the crash? Which postgresql version is this?
--
Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
