Re: Redundant database objects.

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: Redundant database objects.
Дата
Msg-id 4C3C0938.509@joeconway.com
обсуждение исходный текст
Ответ на Re: Redundant database objects.  (Andrew Bartley <ambartley@gmail.com>)
Список pgsql-general
On 07/12/2010 11:07 PM, Andrew Bartley wrote:
>
> I still need some way of finding redundant functions

A bit of a blunt instrument, but you could log all statements for a
while, and then grep through the logs using a list of all functions of
interest to see which ones never show up. Be wary of the performance hit
and rapidly growing log though. Another idea would be to modify a copy
of 8.3.x source code (I think that's what you said you were on in an
earlier post) to emit a NOTICE with a name whenever a function is called
if it meets some criteria.

Joe

--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & Support


Вложения

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

Предыдущее
От: Andras Fabian
Дата:
Сообщение: Re: PG_DUMP very slow because of STDOUT ??
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Testing 9.0beta3 and pg_upgrade