The community will need more details to move forward. Please read the following mail; it is a good guide to how to post queries to get answers and responses quickly.
http://archives.postgresql.org/pgsql-performance/2004-06/msg00235.php Be a better student, ask good questions :) Good luck. On 12/21/06, Terry Askew <[EMAIL PROTECTED]> wrote:
Postgres continues to hang while we attempt to dump tables after several successful dumps. Is this a memory issue. Where is the data being dumped to…Is it being temporarily stored in some repository that can only handle so much data before it produces an exception message. This is critical in that our user community has all but lost faith in our software. We run a batch process right before data profiles are being created at which point Postgres stalls, and the batch process completes perfectly every night. This will obviously affect any user attempting to iteratively delete large quantities of data before performing the next operation. Please Help….Willing to do whatever it takes to resolve this issue, and I assure you that it will increase the stability of Postgres. Sincerely, Terry Askew Foresight Technologies, LLC. Executive VP, Software Development 770-656-9876
-- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | yahoo }.com
