Re: new BUG: "postgresql 9.2.3: very long query time"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Claude Speed <gta3user(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: new BUG: "postgresql 9.2.3: very long query time"
Date: 2013-02-23 16:25:24
Message-ID: 2933.1361636724@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jeff Janes <jeff(dot)janes(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2013-02-23 19:10:30 Re: BUG #7903: EAN13s are shown ISBN values
Previous Message Jeff Janes 2013-02-23 16:02:44 new BUG: "postgresql 9.2.3: very long query time"