[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] new BUG: "postgresql 9.2.3: very long query time"
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2013-02-23 16:25:24
Message-ID: 2933.1361636724 () sss ! pgh ! pa ! us
[Download RAW message or body]

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


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]