Hello everybody,

we've developed a function which reads a huge amount
of data from postgres and, being recursive, does
several memory-intensive elaborations and writes the
results back on two postgres tables. No memory context
switch has been done in our function.

Now we have to compare this function with another one
which performs the same elaborations but reads the
data from a binary file and stores the results on
another file.

Both of them work exactly in the same way (as we've
simply ported our postgres module to work in memory)
but we've noticed a rather different memory usage in
the two cases. The in-memory function seems to have a
lot more of memory to work on, while the postgres one
stops for memory exhausted as soon as the data size
increases over a certain limit.

As far as we know, this could be due to the limited
size of the TopMemoryContext in which the dynamically
loadable modules work.

Is there a way to expand the size of memory available
to our function?

Thanks a lot!

alice and lorena

______________________________________________________________________
Yahoo! Mail: 6MB di spazio gratuito, 30MB per i tuoi allegati, l'antivirus, il filtro Anti-spam
http://it.yahoo.com/mail_it/foot/?http://it.mail.yahoo.com/

Fri, 30 May 2003 20:12:42 +0200 (CEST)
=?iso-8859-1?q?Alice=20Lottini?= <alice_lottini@yahoo.it>
is it possible to enlarge the TopMemoryContext?
=?iso-8859-1?q?Alice=20Lottini?= <alice_lottini@yahoo.it> writes:
> As far as we know, this could be due to the limited
> size of the TopMemoryContext in which the dynamically
> loadable modules work.

TopMemoryContext is just as expansible as any other context.  I'm not
sure what your problem is, but I am quite sure that you've mis-analyzed
it.

			regards, tom lane

Fri, 30 May 2003 15:42:29 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: is it possible to enlarge the TopMemoryContext? 