On Wed, Sep 26, 2012 at 10:59 AM, Christopher Browne <cbbrowne(at)gmail(dot)com> wrote:
> A different place where I wound up having to jump through considerable
> hoops when doing schema analytics was vis-a-vis identifying functions.
> I need to be able to compare schemas across databases, so oid-based
> identification of functions is a total non-starter. It appears that
> the best identification of a function would be based on the
> combination of schema name, function name, and the concatenation of
> argument data types. It wasn't terribly difficult to construct that
> third bit, but it surely would be nice if there was a view capturing
> it, and possibly even serializing it into a table to enable indexing
> on it. Performance-wise, function comparisons turned out to be one of
> the most expensive things I did, specifically because of that mapping
> surrounding arguments.
pg_proc.oid::regprocedure::text has been pretty good to me for this
sort of thing.
The Enterprise PostgreSQL Company
In response to
pgsql-hackers by date
|Next:||From: Amit Kapila||Date: 2012-09-27 13:27:54|
|Subject: Re: [WIP] Performance Improvement by reducing WAL for Update Operation|
|Previous:||From: Robert Haas||Date: 2012-09-27 13:22:40|
|Subject: Re: data to json enhancements|