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é
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?? |