Here's a followup to my first message:

    When I just try 'vacuum verbose' the vacuum goes through fine
without aborting the backend. So it appears to be a problem with
analyzing the optimizer indexing.

-Tony



================================================================

For those that missed my first message:

I've been getting a strange error from the vacuum command. When I try

'vacuum verbose analyze' the vacuum goes through the tables fine until

just after finishing one particular table. Then I get the error:

NOTICE: AbortTransaction and not in in-progress state

pqReadData() -- backend closed the channel unexpectedly.

        This probably means the backend terminated abnormally

        before or while processing the request.

We have lost the connection to the backend, so further processing is

impossible. Terminating.

When I try to vacuum the tables individually, I get no problems with

aborted backends.

Does anyone know what is going on here?

-Tony


Thu, 12 Aug 1999 16:57:13 -0700
"G. Anthony Reina" <reina@nsi.edu>
Followup to: Aborted Transaction During Vacuum