"Guillaume Smet" <[EMAIL PROTECTED]> wrote:

> It's better but still slower than 8.2.

It probablly comes from 'var-varlena' feature in 8.3. Now we store
text fields in a compact format on disks and extract them on access.
It consumes some CPU cycles. If all of data are in buffer cache
and the encoding of database is single-byte encodings, the performance
of LIKE in 8.3 was 10-20% slower than 8.2 on my tests.

ITAGAKI Takahiro
NTT Open Source Software Center

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to