Postgres Pro
Downloads
Home   >   mailing lists

Re: subselect requires offset 0 for good performance. - Mailing list pgsql-performance

From Tom Lane
Subject Re: subselect requires offset 0 for good performance.
Date
Msg-id 4522.1375400642@sss.pgh.pa.us
Whole thread Raw
In response to subselect requires offset 0 for good performance.  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: subselect requires offset 0 for good performance.
List pgsql-performance
Tree view 
Scott Marlowe <scott.marlowe@gmail.com> writes:
> I am running 8.4.15 and can try 8.4.17 if some patch has been applied
> to it to address this issue. I just want to know should I

> A: upgrade to 8.4.17
> or
> B: create a self contained test case.

A quick look at the release notes shows no planner fixes in 8.4.16 or
8.4.17, so it would be rather surprising if (A) helps.

            regards, tom lane

pgsql-performance by date:

Previous
From: Sergey Burladyan
Date:
Subject: Re: Looks like merge join planning time is too big, 55 seconds
Next
From: Sergey Burladyan
Date:
Subject: Re: Looks like merge join planning time is too big, 55 seconds