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.
vacuum analyze fails with latest cvs version
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)
No file was uploaded with this report
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2001-01-01 18:55:25|
|Subject: Re: vacuum analyze fails with latest cvs version |
|Previous:||From: Peter Eisentraut||Date: 2000-12-31 11:18:59|
|Subject: Re: Re: NetBSD/Alpha and rkirkpat's patch [was Re: regress
failed tests.. SERIOUS?] |