Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.2b2 problem using like 'XXX%' sequential scan - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: 7.2b2 problem using like 'XXX%' sequential scan
Date
Msg-id 3BF27903.C75AEB76@fourpalms.org
Whole thread Raw
In response to 7.2b2 problem using like 'XXX%' sequential scan  (Giuseppe Tanzilli - CSF <g.tanzilli@gruppocsf.com>)
List pgsql-hackers
Tree view 
...
> All platform  are linux/i386 using redhat 7.2 and latest libraries

I'm guessing that one platform has "locale" enabled (or some combination
of multibyte parameters?), whereas the other does not. SMP will not make
a difference in configuration or optimizer choices.

The good news is that you have *one* machine which does what you want,
so we know that we can get the other one doing that too :)
                    - Thomas

pgsql-hackers by date:

Previous
From: Giuseppe Tanzilli - CSF
Date:
Subject: Re: 7.2b2 problem using like 'XXX%' sequential scan
Next
From: "Eaglet"
Date:
Subject: handling exceptions, really not simple... :-((