Re: How much expensive are row level statistics?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How much expensive are row level statistics?
Дата
Msg-id 18416.1134691599@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How much expensive are row level statistics?  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: How much expensive are row level statistics?  (Kevin Brown <kevin@sysexperts.com>)
Re: How much expensive are row level statistics?  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-performance
Michael Fuhr <mike@fuhr.org> writes:
> Does the backend support, or could it be easily modified to support,
> a mechanism that would post the command string after a configurable
> amount of time had expired, and then continue processing the query?

Not really, unless you want to add the overhead of setting a timer
interrupt for every query.  Which is sort of counterproductive when
the motivation is to reduce overhead ...

(It might be more or less free if you have statement_timeout set, since
there would be a setitimer call anyway.  But I don't think that's the
norm.)

            regards, tom lane

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: How much expensive are row level statistics?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Overriding the optimizer