I have a table.  When I vacuum verbose it...

mail=# vacuum verbose tblemaildomain ;
NOTICE:  --Relation tblemaildomain--
NOTICE:  Pages 199: Changed 0, reaped 0, Empty 0, New 0; Tup 27494: Vac 0,
Keep/VTL 1/0, Crash 0, UnUsed 0, MinLen 40, MaxLen 80; Re-using:
Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.02u sec.
NOTICE:  Index tblemaildomain_pkey: Pages 70; Tuples 27494. CPU 
0.00s/0.03u sec.
NOTICE:  Index tblemaildomain_oid: Pages 70; Tuples 27494. CPU 0.00s/0.04u 
sec.
VACUUM

When I vacuum verbose analyze it...

mail=# vacuum verbose analyze tblemaildomain ;
NOTICE:  --Relation tblemaildomain--
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.

Thoughts/solutions?  Thanks...

- K

Kristofer Munn * KMI * 732-254-9305 * AIM KrMunn * http://www.munn.com/


Sat, 30 Sep 2000 13:39:42 -0400 (EDT)
Kristofer Munn <kmunn@munn.com>
Crash during vacuum analyze only...