Re: [SQL] PostgreSQL server terminated by signal 11

> De : jeff@glacier.frostconsultingllc.com
> [mailto:jeff@glacier.frostconsultingllc.com] De la part de Jeff Frost
> Envoyé : jeudi, juillet 27, 2006 12:07
> À : Daniel Caune
> Cc : pgsql-sql@postgresql.org; pgsql-admin@postgresql.org
> Objet : Re: [SQL] PostgreSQL server terminated by signal 11
>
> On Thu, 27 Jul 2006, Daniel Caune wrote:
>
> > My PostgreSQL server running on a Linux machine is terminated by signal
> > 11 whenever I try to create some indexes on a table, which contains
> > quite a lot of data.  However I succeeded in creating some other indexes
> > without having the PostgreSQL server terminated:
>
> Daniel,
>
> I would guess this is more appropriate for the -admin list so I cc'd it.
>
> I think you are most likely running out of memory or running up against a
> ulimit on memory.  I would first check my ulimit settings on the postgres
> user
> and see if they are a bit small.
>

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. 

Regards,


--
Daniel