Re: subselect requires offset 0 for good performance.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: subselect requires offset 0 for good performance.
Date: 2013-08-01 23:44:02
Message-ID: 4522.1375400642@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sergey Burladyan 2013-08-02 00:16:46 Re: Looks like merge join planning time is too big, 55 seconds
Previous Message Sergey Burladyan 2013-08-01 21:50:23 Re: Looks like merge join planning time is too big, 55 seconds