Re: new BUG: "postgresql 9.2.3: very long query time" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: new BUG: "postgresql 9.2.3: very long query time"
Date
Msg-id 2933.1361636724@sss.pgh.pa.us
Whole thread Raw
In response to new BUG: "postgresql 9.2.3: very long query time"  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-bugs
Jeff Janes <jeff.janes@gmail.com> writes:
> On Friday, February 22, 2013, Tom Lane wrote:
>> Try increasing from_collapse_limit to 11 or more.

> I've increased it to 20 and still no luck.

Huh --- that improved the results for me.

> I've stripped it down to this:

I'm not sure if that's exactly the same issue the OP is hitting, but
will take a look at it.  Thanks for the simpler test case.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: new BUG: "postgresql 9.2.3: very long query time"
Next
From: Peter Geoghegan
Date:
Subject: Re: BUG #7903: EAN13s are shown ISBN values