Re: [PATCHES] ilike multi-byte pattern cache

2007-09-24 Thread ITAGAKI Takahiro
Andrew Dunstan <[EMAIL PROTECTED]> wrote: > The attached patch implements a one-value pattern cache for the > multi-byte encoding case for ILIKE. This reduces calls to lower() by > (50% -1) in the common case where the pattern is a constant. My own > testing and Guillaume Smet's show that thi

Re: [PATCHES] ilike multi-byte pattern cache

2007-09-22 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: The attached patch implements a one-value pattern cache for the multi-byte encoding case for ILIKE. This reduces calls to lower() by (50% -1) in the common case where the pattern is a constant. My own testing and Guillaume Smet's

Re: [PATCHES] ilike multi-byte pattern cache

2007-09-22 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > The attached patch implements a one-value pattern cache for the > multi-byte encoding case for ILIKE. This reduces calls to lower() by > (50% -1) in the common case where the pattern is a constant. My own > testing and Guillaume Smet's show that this