Обсуждение: Internal Error XXOO...Mission Critical

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

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 <taskew@demandforesight.com> 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=85Is it being temporarily stored in some repository that can only hand=
le 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 ev=
ery
> night.
>
>
>
> This will obviously affect any user attempting to iteratively delete large
> quantities of data before performing the next operation.
>
>
>
> Please Help=85.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
>



--=20
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com