Thread: AW: [HACKERS] Error "vacuum pg_proc"

AW: [HACKERS] Error "vacuum pg_proc"

From
Zeugswetter Andreas SB
Date:
> > It turns out that for an index on a single text column, the maximum
> > safe text length is 2700 bytes.  So the correct check for dangerous
> > procedure definitions in 6.5.* is
> 
> This is another argument to try and get long tuples into 7.0.

The limit of 2700 is btree specific, and imho a more than actually  
reasonable limit for a btree key.
Anybody wanting an index on a larger key would usually be 
better off with different indexing methods, like a functional
btree, hash, or text index.

Andreas