From 6563e9e2e8b15350e4cb99b86f2f7dec54722155 Mon Sep 17 00:00:00 2001
From: Tom Lane
Date: Wed, 16 Jul 2008 16:55:24 +0000
Subject: Add a "provariadic" column to pg_proc to eliminate the remarkably
 expensive need to deconstruct proargmodes for each pg_proc entry inspected by
 FuncnameGetCandidates().  Fixes function lookup performance regression caused
 by yesterday's variadic-functions patch.

In passing, make pg_proc.probin be NULL, rather than a dummy value '-',
in cases where it is not actually used for the particular type of function.
This should buy back some of the space cost of the extra column.
---
 doc/src/sgml/catalogs.sgml | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index 7accea0f76c..83be70ca666 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.169 2008/07/16 01:30:21 tgl Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.170 2008/07/16 16:55:23 tgl Exp $ -->
 <!--
  Documentation of the system catalogs, directed toward PostgreSQL developers
  -->
@@ -3569,6 +3569,14 @@
       <entry>Estimated number of result rows (zero if not <structfield>proretset</>)</entry>
      </row>
 
+     <row>
+      <entry><structfield>provariadic</structfield></entry>
+      <entry><type>oid</type></entry>
+      <entry><literal><link linkend="catalog-pg-type"><structname>pg_type</structname></link>.oid</literal></entry>
+      <entry>Data type of the variadic array parameter's elements,
+       or zero if the function does not have a variadic parameter</entry>
+     </row>
+
      <row>
       <entry><structfield>proisagg</structfield></entry>
       <entry><type>bool</type></entry>
-- 
cgit v1.2.3