Re: audit table containing Select statements submitted

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: audit table containing Select statements submitted
Дата
Msg-id 20060515154213.GK26212@pervasive.com
обсуждение исходный текст
Ответ на Re: audit table containing Select statements submitted  ("Hogan, James F. Jr." <JHogan@seton.org>)
Список pgsql-hackers
How do you hope to avoid this overhead when you're looking to track
information on every single SELECT statement? Or were you looking to
only log access to some specific tables?

On Mon, May 15, 2006 at 09:38:54AM -0500, Hogan, James F. Jr. wrote:
> Thank you all for the effort you put into response.
> 
> The biggest thing I want to avoid isn't so much having to parse through
> the log files but to avoid turning on such extensive logging altogether.
> 
> I am not sure what kind of additional load logging to this extent may
> add.
> 
> Looks like I am not going to have much in the way of alternative.
> 
> Maybe some day.
> 
> Good news is that most access is via Web Interface and I capture most
> activity that way.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [PORTS] Compiling on 8.1.3 on Openserver 5.05
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Creating a Pseudocolumn