AW: [HACKERS] Error "vacuum pg_proc"

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: [HACKERS] Error "vacuum pg_proc"
Дата
Msg-id 219F68D65015D011A8E000006F8590C603FDC1E0@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список pgsql-hackers
> > 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


В списке pgsql-hackers по дате отправления: