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