Re: Problem reloading regression database

From: Brent Verner <brent(at)rcfile(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Problem reloading regression database
Date: 2002-01-15 06:10:57
Message-ID: 20020115061057.GA10705@rcfile.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

[2002-01-15 01:07] Tom Lane said:
| Brent Verner <brent(at)rcfile(dot)org> writes:
| > Yes, and I'm seeing no new problems (so far), but there is a problem
| > in the current copy.c. Running the following on unmodified 7.2b5
| > causes the backend to consume 17-18Mb of memory.
|
| Probably that's just the space consumed for the pending-trigger events
| created by the AFTER trigger that implements the foreign key check.
| There should be a provision for shoving that list out to disk when
| it gets too large ... but it ain't happening for 7.2.

gotcha. I'll move on along then...

thanks.
brent

--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-01-15 06:15:23 Re: About pg_upgrade
Previous Message Tom Lane 2002-01-15 06:07:57 Re: Problem reloading regression database