Vacuum problem on large table

From: mordicus <mordicus(at)free(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Vacuum problem on large table
Date: 2001-05-31 18:37:28
Message-ID: 9f6330$286d$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This table have 1005540 tuples

Index on issn field.

CREATE TABLE "record_blob" (
"issn" character varying(9) NOT NULL,
"data" varchar(10000)
);

vacuum verbose analyse record_blob;
NOTICE: --Relation record_blob--
NOTICE: Pages 62437: Changed 0, reaped 0, Empty 0, New 0; Tup 1005540: Vac
0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 80, MaxLen 2032; Re-using:
Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 4.57s/0.37u sec.
NOTICE: --Relation pg_toast_44260091--
NOTICE: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 2: Vac 0,
Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 63, MaxLen 2034; Re-using:
Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index pg_toast_44260091_idx: Pages 2; Tuples 2. CPU 0.00s/0.00u
sec.
NOTICE: Analyzing...
ERROR: Memory exhausted in AllocSetAlloc(875769886)

In pglog i have :
TopMemoryContext: 57392 total in 4 blocks; 1968 free (4 chunks); 55424 used
TopTransactionContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
DeferredTriggerXact: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
TransactionCommandContext: 57344 total in 3 blocks; 44968 free (24 chunks);
12376 used
QueryContext: 8192 total in 1 blocks; 7496 free (1 chunks); 696 used
Vacuum: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used
DeferredTriggerSession: 8192 total in 1 blocks; 8176 free (0 chunks); 16
used
CacheMemoryContext: 516096 total in 6 blocks; 213592 free (94 chunks);
302504 used
pg_user: 5120 total in 5 blocks; 912 free (0 chunks); 4208 used
PortalMemory: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used
DynaHash: 24576 total in 2 blocks; 6392 free (2 chunks); 18184 used
ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
ERROR: Memory exhausted in AllocSetAlloc(875769886)

Help ! :)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mordicus 2001-05-31 18:38:40 Re: Vacuum problem on large table
Previous Message Luis Magaña 2001-05-31 17:26:19 pg_dump & pg_dumpall problem.