size of function body

From: Ralph Graulich <maillist(at)shauny(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: size of function body
Date: 2002-07-16 17:43:43
Message-ID: Pine.LNX.4.21.0207161937020.9511-100000@shauny.shauny.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

after some fooling around I figured out that a function body can't be
larger than the defined postgres' block size, which defaults to 8192
byte. The same time I read enlarging the default block size has a negative
performance impact.

How would the "long time experts" decide on the following issues given:

(1) running postgres 7.2.1 on a 32 bit system
(2) needing (if not splitting up, which would be a tedious work) about at
least 30 / 35 functions larger than about 20 to 25 kbyte each
(3) those functions are called for almost every query, which means all
input/output from the application to the database is done by calling
functions

Another issue: If one has got nested function (function 1 calling function
2, 3, 4, 5 to do the work) and a "subfunction" (2, 3, 4 or 5) gets dropped
and recreated, the reference of function 1 to that subfunction gets
lost. Is there any easy way to "recompile" all depending subfunctions?

If anyone wants to point me to some documentation, I am glad to read
through those issues on my own. Just didn't find anything documented.

Kind regards
... Ralph ...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Boes 2002-07-16 17:50:44 lo_unlink from a trigger
Previous Message Kevin Brannen 2002-07-16 17:29:25 Re: Getting postmaster: StreamConnection: accept: The connection