Error with Vaccum Analyze !?
| От | Hervé Piedvache |
|---|---|
| Тема | Error with Vaccum Analyze !? |
| Дата | |
| Msg-id | 3A1161D2.72D4B103@elma.fr обсуждение исходный текст |
| Ответы |
Re: Error with Vaccum Analyze !?
|
| Список | 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é
В списке pgsql-general по дате отправления: