X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9BC219FB20F for ; Thu, 27 Jul 2006 17:06:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 48333-07 for ; Thu, 27 Jul 2006 17:05:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id CEBB39FB209 for ; Thu, 27 Jul 2006 17:05:53 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k6RK5psI027283; Thu, 27 Jul 2006 16:05:51 -0400 (EDT) To: "Daniel Caune" cc: pgsql-sql@postgresql.org Subject: Re: PostgreSQL server terminated by signal 11 In-reply-to: <1E293D3FF63A3740B10AD5AAD88535D202B64A4D@UBIMAIL1.ubisoft.org> References: <1E293D3FF63A3740B10AD5AAD88535D202B64A4D@UBIMAIL1.ubisoft.org> Comments: In-reply-to "Daniel Caune" message dated "Thu, 27 Jul 2006 12:00:47 -0400" Date: Thu, 27 Jul 2006 16:05:51 -0400 Message-ID: <27282.1154030751@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.037 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/340 X-Sequence-Number: 25914 "Daniel Caune" writes: > 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. Judging from your examples it's got something to do with the partial index WHERE clause. What PG version is this exactly? If you leave out different parts of the WHERE, does it still crash? Does the crash happen immediately after you give the command, or does it run for awhile? It might be worth getting a stack trace from the failure (best way is to attach to the running backend with gdb, provoke the crash, and do "bt" --- search for "gdb" in the archives if you need details). regards, tom lane