Re: Blocks read for index scans

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Blocks read for index scans
Дата
Msg-id 9369.1145027575@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Blocks read for index scans  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: Blocks read for index scans  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-performance
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> In my case it would be helpful to break the heap access numbers out
> between seqscans and index scans, since each of those represents very
> different access patterns. Would adding that be a mess?

Yes; it'd require more counters-per-table than we now keep, thus
nontrivial bloat in the stats collector's tables.  Not to mention
incompatible changes in the pgstats views and the underlying functions
(which some apps probably use directly).

            regards, tom lane

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

Предыдущее
От: "Jignesh K. Shah"
Дата:
Сообщение: Re: bad performance on Solaris 10
Следующее
От: Ian Westmacott
Дата:
Сообщение: merge>hash>loop