The following bug has been logged online:

Bug reference: 2853
Logged by: Terry Askew
Email address: taskew (AT) demandforesight (DOT) com
PostgreSQL version: 8.1.5
Operating system: Windows Server 2000
Description: Internal error XXOO Hangs while attempting to clear
table after several successful iterations
Details:

Batch Process completes, then Data Profiles creation is attempted, but
stalls after several Profiles create. To create the next profile,we require
a data dump of the current table in memory just created, so that as the
profiles are being created on the fly, the table acts as a tempTable.

This is the only technical issue left to resolve so that the LIVE system can
be used and accepted by our users.

Pls Help.

Sincerely,
Terry Askew
Executive VP, Software Development
Foresight Technologies, LLC.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

upgrade to 8.2.0
that problem was fixed there (had it myself as well)

- thomas

----- Original Message -----
From: "Terry Askew" <taskew (AT) demandforesight (DOT) com>
To: <pgsql-bugs (AT) postgresql (DOT) org>
Sent: Thursday, December 21, 2006 6:13 PM
Subject: [BUGS] BUG #2853: Internal error XXOO Hangs while attempting to
clear table after several successful iterations




---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend