Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group