Dirk Försterling wrote:
> There were some dumb queries with timestamps, performing much slower
> with Linux-2.6.5 compared to Linux-2.4.25:
>
> The queries used something like this (ts is a TIMESTAMP):
> ... AND ts LIKE '2003-04-%'
I'm guessing an index isn't being used because your LANG is
something-UTF-8 and that got picked up when you recreated your database.
Try recreating the database with the C locale and see if that does it.
--
Richard Huxton
Archonet Ltd