Re: pg_stat_statements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_stat_statements
Дата
Msg-id 14698.1213386467@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_stat_statements  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On Fri, 2008-06-13 at 17:33 +0900, ITAGAKI Takahiro wrote:
>> We can write sql statements in server logs and gather them using some
>> tools (pgfouine and pqa) even now, but statement logging has
>> unignorable overhead.

> I would prefer to look at ways to reduce the current overhead rather
> than change to another system entirely. 

It's also the case that adding to the stats collector is hardly going to
have "ignorable" overhead.  (And you're dreaming if you think you can do
it like pg_stat_activity, because this can't be a fixed-size array with
a trivial indexing scheme.)
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses
Следующее
От: "Dickson S. Guedes"
Дата:
Сообщение: Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses