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
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?] |