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 <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
