vacuum analyze fails with latest cvs version

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: vacuum analyze fails with latest cvs version
Date: 2001-01-01 01:17:31
Message-ID: 200101010117.f011HVE44848@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jukka Honkela (jukka(dot)honkela(at)ee(dot)oulu(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-01-01 18:55:25 Re: vacuum analyze fails with latest cvs version
Previous Message Peter Eisentraut 2000-12-31 11:18:59 Re: Re: NetBSD/Alpha and rkirkpat's patch [was Re: regress failed tests.. SERIOUS?]