Excerpts from Dimitri Fontaine's message of vie oct 22 16:43:56 -0300 2010:
> Dimitri Fontaine <dimitri@2ndQuadrant.fr> writes:
> > For information, when we talk about performance problem, please note
> > that on my workstation with a default setup (not that it's important
> > here) we're talking about 86,420 ms for a loop of 100
> > perform * from pg_extensions;
BTW it strikes me that it would be easier on the code that there were
just a couple of simple functions, one returning the list of installed
extensions and another one returning the list of installable
extensions. The rest of SRF functions needn't be implemented in C, you
could implement them in SQL instead by joining to pg_depend and whatnot.
Also, PFA a couple of minor fixes.
--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support