"Gregory Stark" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to