Re: 7.2b2 problem using like 'XXX%' sequential scan

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Giuseppe Tanzilli - CSF <g(dot)tanzilli(at)gruppocsf(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 7.2b2 problem using like 'XXX%' sequential scan
Date: 2001-11-14 14:00:35
Message-ID: 3BF27903.C75AEB76@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

...
> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2001-11-14 14:11:05 Re: Use of 'now'
Previous Message Giuseppe Tanzilli - CSF 2001-11-14 11:59:28 Re: 7.2b2 problem using like 'XXX%' sequential scan