Re: SELECT LIMIT 1 VIEW Performance Issue - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: SELECT LIMIT 1 VIEW Performance Issue
Date
Msg-id 4334E0D3.1080504@paradise.net.nz
Whole thread Raw
In response to Re: SELECT LIMIT 1 VIEW Performance Issue  (K C Lau <kclau60@netvigator.com>)
List 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

pgsql-performance by date:

Previous
From: K C Lau
Date:
Subject: Re: SELECT LIMIT 1 VIEW Performance Issue
Next
From: Oleg Bartunov
Date:
Subject: Re: tsearch2 seem very slow