"Gregory Stark" <stark@enterprisedb.com> writes:
> Is your database initialized with C locale? If so then length(text) is
> optimized to not have to detoast:
>
> if (pg_database_encoding_max_length() == 1)
> PG_RETURN_INT32(toast_raw_datum_size(str) - VARHDRSZ);
Of course I got that wrong. The question is "is your database in a single-byte
encoding" which isn't the same as being in C locale.
-- Gregory Stark EnterpriseDB http://www.enterprisedb.com
