RE: [HACKERS] "CANNOT EXTEND" - - Mailing list pgsql-hackers

From Peter Mount
Subject RE: [HACKERS] "CANNOT EXTEND" -
Date
Msg-id A9DCBD548069D211924000C00D001C441A09AA@exchange.maidstone.gov.uk
Whole thread Raw
Responses Re: [HACKERS] "CANNOT EXTEND" -
List pgsql-hackers
Is this from vacuum or pg_dump?

I'm just wondering if vacuum cannot cope with a table that is >1Gb
(hence in two segments), and when cleaned down, is <1Gb (one segment).

Saying that, why is it saying the tuple is too big? What is creating
that tuple?

-----Original Message-----
From: Bruce Momjian [mailto:maillist@candle.pha.pa.us]
Sent: Tuesday, March 23, 1999 2:55 PM
To: tim@perdue.net
Cc: hackers@postgreSQL.org
Subject: Re: [HACKERS] "CANNOT EXTEND" -


> 
> Bruce, for the most part, I have worked around the problems with
> pg_dump.
> 
> But I am getting this error now, and it is worrisome:
> 
> NOTICE:  Can't truncate multi-segments relation tbl_mail_archive
> ERROR:  Tuple is too big: size 10024
> 

Can someone comment on this?  It is coming from
./backend/storage/smgr/md.c in mdtruncate().  Is this table very large?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania
19026


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] "CANNOT EXTEND" -
Next
From: Silvia_Brown9@gte.net
Date:
Subject: Find Out What The Future Holds For You?