Re: SELECT LIMIT 1 VIEW Performance Issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: K C Lau <kclau60(at)netvigator(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: SELECT LIMIT 1 VIEW Performance Issue
Date: 2005-09-22 15:41:14
Message-ID: 29336.1127403674@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

K C Lau <kclau60(at)netvigator(dot)com> writes:
> At 20:48 05/09/22, Simon Riggs wrote:
>> Even if this were fixed for 8.1, which seems unlikely, would you be able
>> to move to that release immediately?

> Yes. In fact when we first developed our system a few years ago, we tested
> on MS7.0, Oracle 8 and PG 7.1.1 and we did not hit that problem.

It's really not credible that PG 7.1 did any better with this than
current sources do. The subplan mechanism hasn't changed materially
since about 6.5. It could be that 7.1's performance was simply so
bad across the board that you didn't notice ...

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2005-09-22 16:16:23 Re: SELECT LIMIT 1 VIEW Performance Issue
Previous Message K C Lau 2005-09-22 14:56:47 Re: SELECT LIMIT 1 VIEW Performance Issue