vacuum analyze fails with latest cvs version - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject vacuum analyze fails with latest cvs version
Date
Msg-id 200101010117.f011HVE44848@hub.org
Whole thread Raw
Responses Re: vacuum analyze fails with latest cvs version  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Jukka Honkela (jukka.honkela@ee.oulu.fi) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
vacuum analyze fails with latest cvs version

Long Description
I have a table ('messages') of email messages (subject, sender etc..) which
has a column (of type 'text') that contains the actual body of the
messages. Some of these messages are longer than 8KB so the TOAST
thing is being used.
Problem 1: "vacuum messages;" works but "vacuum analyze messages;"
kills the backend. Vacuum analyze worked (afaik) at least a month ago.
Problem 2: "cluster messages_index on messages" fails on message:
ERROR:  Tuple is too big: size 29704, max size is 8136
The latter problem has existed as long as TOAST support has existed,
to my experience. (Linux, RH 7.0, i386)

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Re: NetBSD/Alpha and rkirkpat's patch [was Re: regress failed tests.. SERIOUS?]
Next
From: Tom Lane
Date:
Subject: Re: vacuum analyze fails with latest cvs version