Re: TOAST usage setting

"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