Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group