On Tue, Sep 9, 2014 at 6:36 AM, <lists@xxxxxxxxxxxxxxxxxx> wrote: > What other information should I provide? We have the machine available if > necessary. This can be reproduced without especially LEFT OUTER JOIN, and system crashes as long as index path is taken in planner, and that WHERE clause uses a given combination of OR and AND like the one in the query given. Here is a more simple example: create table aa (a int); create index aai on aa(a); select a1.a from aa a1, aa a2 where a1.a = 0 or (a1.a = 0 or a1.a = 1) and a2.a = 0; Some bisecting is showing as well that the commit at the origin of the regression is f343a88. Regards, -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general