Re: [HACKERS] Error "vacuum pg_proc" - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Error "vacuum pg_proc"
Date
Msg-id 25187.946264976@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Error "vacuum pg_proc"  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] Error "vacuum pg_proc"
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> It turns out that for an index on a single text column, the maximum
>> safe text length is 2700 bytes.

> This is another argument to try and get long tuples into 7.0.

I think Jan might have enough on his plate already without trying to
TOAST the index code along with the plain-table code.  But if he can
get it done, great!

One thing this does bring up is that the maximum safe tuple length is
dependent on the index or table type.  The toaster's API had better
be designed accordingly...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Error "vacuum pg_proc"
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Error "vacuum pg_proc"