Re: [SQL] PostgreSQL server terminated by signal 11 - Mailing list pgsql-admin

From Jeff Frost
Subject Re: [SQL] PostgreSQL server terminated by signal 11
Date
Msg-id Pine.LNX.4.64.0607270904450.11632@discord.home.frostconsultingllc.com
Whole thread Raw
List pgsql-admin
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.

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: VACUUM ANALYZE suddenly taking forever
Next
From: "Daniel Caune"
Date:
Subject: Re: [SQL] PostgreSQL server terminated by signal 11