Re: Access statistics

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Access statistics
Дата
Msg-id 686.991404521@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Access statistics  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: Access statistics  (Jan Wieck <JanWieck@Yahoo.com>)
Список pgsql-hackers
Jan Wieck <JanWieck@Yahoo.com> writes:
>     So outing myself not beeing a *real programmer*, this is what
>     I have so far:

Hmm ... what is the performance of all this like?  Seems like a lot
of overhead.  Can it be turned off?

>     * Backends call some collector functions  at  various  places
>       now  (these  will  finally  be macros), that count up table
>       scans, tuples returned by scans,  buffer  fetches/hits  and
>       the like.

Have you removed the existing stats-gathering support
(backend/access/heap/stats.c and so on)?   That would buy back
at least a few of the cycles involved ...
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: cache lookup for proc 43030134 failed
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: Access statistics