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