Re: Big insert/delete memory problems - Mailing list pgsql-general

From Tom Lane
Subject Re: Big insert/delete memory problems
Date
Msg-id 1260.1048018660@sss.pgh.pa.us
Whole thread Raw
In response to Re: Big insert/delete memory problems  (Kurt Overberg <kurt@hotdogrecords.com>)
Responses Re: Big insert/delete memory problems  (Kurt Overberg <kurt@hotdogrecords.com>)
List pgsql-general
Kurt Overberg <kurt@hotdogrecords.com> writes:
> Darn it, I knew I forgot something.  I'm running on redhat 7.3, with
> postgresql version 7.3.2, accessing it through tomcat 4.1.18.  It
> APPEARS that its the insert that bumps the memory.  Here's the schema
> for the member table:

I created the two tables, loaded some dummy data into member, and
inserted/selected like mad ... no sign of memory bloat.  So there's
something else involved here.  Any plpgsql functions being used?
Triggers or foreign keys?

            regards, tom lane

pgsql-general by date:

Previous
From: Kurt Overberg
Date:
Subject: Re: Big insert/delete memory problems
Next
From: Kurt Overberg
Date:
Subject: Re: Big insert/delete memory problems