Crash during vacuum analyze only...

From: Kristofer Munn <kmunn(at)munn(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Crash during vacuum analyze only...
Date: 2000-09-30 17:39:42
Message-ID: Pine.LNX.4.10.10009301337560.9581-100000@munn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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/

Browse pgsql-hackers by date

  From Date Subject
Next Message Louis-David Mitterrand 2000-10-01 08:11:02 failed to compile a C++ SPI function
Previous Message Peter Eisentraut 2000-09-30 11:03:31 Re: grant/revoke bug with delete/update