Re: SELECT LIMIT 1 VIEW Performance Issue

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: K C Lau <kclau60(at)netvigator(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SELECT LIMIT 1 VIEW Performance Issue
Date: 2005-09-24 05:14:59
Message-ID: 4334E0D3.1080504@paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

K C Lau wrote:

> I'm wondering if this performance issue is common enough for other users
> to merit a fix in pg, especially as it seems that with MVCC, each of the
> data records need to be accessed in addition to scanning the index.
>

Yes - there are certainly cases where index only access (or something
similar, like b+tree tables) would be highly desirable.

From what I have understood from previous discussions, there are
difficulties involved with producing a design that does not cause new
problems...

regards

Mark

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Meir Maor 2005-09-24 05:24:01 Re: Releasing memory during External sorting?
Previous Message K C Lau 2005-09-24 03:18:24 Re: SELECT LIMIT 1 VIEW Performance Issue