Re: commiting in/between functions - Mailing list pgsql-general

From Tom Lane
Subject Re: commiting in/between functions
Date
Msg-id 5123.1047396848@sss.pgh.pa.us
Whole thread Raw
In response to commiting in/between functions  (Magnus Månsson <ganja@0x63.nu>)
Responses Re: commiting in/between functions
List pgsql-general
Magnus =?iso-8859-1?Q?M=E5nsson?= <ganja@0x63.nu> writes:
> Making the script wasnt any big problem, the problem is the amount of memory
> it wants to use, if I had a terabyte of memory I do not think that would be
> enough, if I try to convert a 100th of the database at a time it uses all
> the swap, 1G and the 512M memory.

It would help if you showed us the function and told us what version of
Postgres you're talking about.  This could just be a garden-variety
memory leakage problem.

            regards, tom lane

pgsql-general by date:

Previous
From: wsheldah@lexmark.com
Date:
Subject: Upgrading to 7.3 on Mandrake Linux
Next
From: Tom Lane
Date:
Subject: Re: General Performance questions