Re: SELECT LIMIT 1 VIEW Performance Issue

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: SELECT LIMIT 1 VIEW Performance Issue
Дата
Msg-id 4334E0D3.1080504@paradise.net.nz
обсуждение исходный текст
Ответ на Re: SELECT LIMIT 1 VIEW Performance Issue  (K C Lau <kclau60@netvigator.com>)
Список 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 по дате отправления:

Предыдущее
От: K C Lau
Дата:
Сообщение: Re: SELECT LIMIT 1 VIEW Performance Issue
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: tsearch2 seem very slow