Re: [SQL] PostgreSQL server terminated by signal 11

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
comparedto 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
wheresome data are imported in from OLTP databases, this every day.  Indexes are dropped before inserting data and
createdwhen 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@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954