Re: Shouldn't the planner have a higher cost for reverse index scans?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Shouldn't the planner have a higher cost for reverse index scans?
Дата
Msg-id 49DF8603.3000006@agliodbs.com
обсуждение исходный текст
Ответ на Re: Shouldn't the planner have a higher cost for reverse index scans?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Shouldn't the planner have a higher cost for reverse index scans?
Список pgsql-performance
Tom,

> Right, because they do.  If you think otherwise, demonstrate it.
> (bonnie tests approximating a reverse seqscan are not relevant
> to the performance of indexscans.)

Working on it.  I *think* I've seen this issue in the field, which is
why I brought it up in the first place, but getting a good test case is,
of course, difficult.


--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com

В списке pgsql-performance по дате отправления:

Предыдущее
От: Scott Carey
Дата:
Сообщение: Re: Using IOZone to simulate DB access patterns
Следующее
От: Tom Lane
Дата:
Сообщение: Re: plpgsql arrays