Error with Vaccum Analyze !?

From: Hervé Piedvache <herve(at)elma(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Error with Vaccum Analyze !?
Date: 2000-11-14 16:01:22
Message-ID: 3A1161D2.72D4B103@elma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a big trouble, and I'm very disapointed !

I have a table with 99 fields and 32584 records ...
I import it with a : COPY quest from 'quest.txt'

Then I do a VACCUM ANALYZE quest, then I get this message :

pouet=# vacuum analyze quest;
FATAL 1: Memory exhausted in AllocSetAlloc()
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

Please could you give me a solution ... or an explanation ...

If I do a simple VACUUM quest; one time it answer only VACUUM and once I
get :
NOTICE: Rel quest: TID 651/31: OID IS INVALID. TUPGONE 1.
VACUUM

I really don't understand what happend ?

Thanks for your help !

Regards,

--
Hervé

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-11-14 16:03:05 Re: Is this proper UNION behavior??
Previous Message Edward Q. Bridges 2000-11-14 15:39:22 Re: Is this proper UNION behavior??