Re: [HACKERS] Error "vacuum pg_proc"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Error "vacuum pg_proc"
Date: 1999-12-27 03:22:56
Message-ID: 25187.946264976@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-12-27 03:36:19 Re: [HACKERS] Error "vacuum pg_proc"
Previous Message Bruce Momjian 1999-12-27 02:19:48 Re: [HACKERS] Error "vacuum pg_proc"