Re: Redundant database objects. - Mailing list pgsql-general

From Joe Conway
Subject Re: Redundant database objects.
Date
Msg-id 4C3C0938.509@joeconway.com
Whole thread Raw
In response to Re: Redundant database objects.  (Andrew Bartley <ambartley@gmail.com>)
List 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


Attachment

pgsql-general by date:

Previous
From: Andras Fabian
Date:
Subject: Re: PG_DUMP very slow because of STDOUT ??
Next
From: Thomas Kellerer
Date:
Subject: Re: Testing 9.0beta3 and pg_upgrade