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/