Horton

Re: Is Linux 2.6.5 kernel good enough for production?

Richard Huxton <dev@archonet.com>

View thread View on postgr.es
From: Richard Huxton <dev@archonet.com>
To: Dirk Försterling <r@zorbla.de>
Cc: "scott.marlowe" <scott.marlowe@ihs.com>, pgsql-general <pgsql-general@postgresql.org>
Date: 2004-05-17T17:08:48Z
Lists: pgsql-general 
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