Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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/


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group