| From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
|---|---|
| To: | Daniel Caune <daniel(dot)caune(at)ubisoft(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [SQL] PostgreSQL server terminated by signal 11 |
| Date: | 2006-07-27 16:07:08 |
| Message-ID: | Pine.LNX.4.64.0607270904450.11632@discord.home.frostconsultingllc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Caune | 2006-07-27 19:27:55 | Re: [SQL] PostgreSQL server terminated by signal 11 |
| Previous Message | Daniel Caune | 2006-07-27 16:00:47 | PostgreSQL server terminated by signal 11 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Jones | 2006-07-27 16:20:59 | Disk is full, what's cool to get rid of? |
| Previous Message | Daniel Caune | 2006-07-27 16:00:47 | PostgreSQL server terminated by signal 11 |