Re: Error with Vaccum Analyze !?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: herve(at)elma(dot)fr
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error with Vaccum Analyze !?
Date: 2000-11-14 16:39:59
Message-ID: 2793.974219999@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?Q?Herv=E9?= Piedvache <herve(at)elma(dot)fr> writes:
> 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()

That looks like corrupted data in your table. If you can get this
message immediately after creating and loading the table, then I'd
be really interested to see your table definition and data file ...

What Postgres version are you using, anyway?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gunnar R|nning 2000-11-14 16:45:15 Re: Encoding
Previous Message Tom Lane 2000-11-14 16:32:58 Re: Encoding