Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZFxOH-0000W2-Nc for pgsql-admin@arkaria.postgresql.org; Fri, 17 Jul 2015 04:36:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZFxOH-00036Y-1k for pgsql-admin@arkaria.postgresql.org; Fri, 17 Jul 2015 04:36:53 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZFxMg-0001Bp-DB for pgsql-admin@postgresql.org; Fri, 17 Jul 2015 04:35:14 +0000 Received: from mail-pa0-x232.google.com ([2607:f8b0:400e:c03::232]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZFxMd-00076m-KF for pgsql-admin@postgresql.org; Fri, 17 Jul 2015 04:35:13 +0000 Received: by padck2 with SMTP id ck2so53834742pad.0 for ; Thu, 16 Jul 2015 21:35:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=zsdBok8nJNHQ71wEG8rYGP/iWYoXD30cBVbk4HoY/uo=; b=Ly59vtqjQPzLLWg83PUvfaoA/ciwW9Ywx6+F2aEC0CEoQUGtDkzwiuDh9c5siP8dk9 JoTq5PQczV7nqxK32s1CwOwWw48GheK0eXZlq76xGwiNKWRcX+kK+BKodZIzJeSvaOuh 0rysfdqLs39qbeT0+bfBxvxYYJ584o+SgRX8AwMvLEAGq7nWB8FKIIYnr6zuAb8eaQDB 9HqTAQmXstP6ITwnTjDO8z2Kw+uMoyZWGrXgPI5gGQI1egZZ1Q5cE/VtDmApyFsxNMEe mZ9RyW3PEEtJ864BKvwN26TMHrUHufeWCk7YEXckupDaUp1vx/G21U2XUs5v1mv0ba8d ssxg== X-Received: by 10.66.249.233 with SMTP id yx9mr24868262pac.133.1437107709982; Thu, 16 Jul 2015 21:35:09 -0700 (PDT) Received: from ?IPv6:2601:646:8601:379d:31cd:1389:8548:d247? ([2601:646:8601:379d:31cd:1389:8548:d247]) by smtp.gmail.com with ESMTPSA id nz2sm9575413pbb.40.2015.07.16.21.35.09 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Thu, 16 Jul 2015 21:35:09 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2102\)) Subject: Re: segfault when creating index on huge table From: Yiqing Jin In-Reply-To: <26894.1437102971@sss.pgh.pa.us> Date: Thu, 16 Jul 2015 21:35:08 -0700 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <699EB2AC-7BF5-4BD3-AF59-2A5C682D3E69@gmail.com> References: <9256.1437081266@sss.pgh.pa.us> <4D1580D9-D560-45B2-8BA2-97058B6F8D85@gmail.com> <26894.1437102971@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.2102) X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org this is very helpful information. thanks again! > On Jul 16, 2015, at 8:16 PM, Tom Lane wrote: >=20 > Yiqing Jin writes: >> Yes it finished successfully after changing it to 50G! >=20 > OK. That's only a workaround of course. I believe the actual problem > is explained here: > http://www.postgresql.org/message-id/flat/25168.1437091531@sss.pgh.pa.us > If you need a fix before the next minor releases, see > http://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dcommitdiff;h=3Db= 8f368276916b677f0678982e81723fe30e5c582 >=20 > regards, tom lane --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin