X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 580D93A4B28
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 13 Nov 2004 21:39:35 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 80035-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 13 Nov 2004 21:39:28 +0000 (GMT)
Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210])
	by svr1.postgresql.org (Postfix) with ESMTP id 6780D3A4AE1
	for <pgsql-sql@postgresql.org>; Sat, 13 Nov 2004 21:39:29 +0000 (GMT)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id ADB17357A8; Sat, 13 Nov 2004 13:39:27 -0800 (PST)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id AC488357A7; Sat, 13 Nov 2004 13:39:27 -0800 (PST)
Date: Sat, 13 Nov 2004 13:39:27 -0800 (PST)
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: carex <carex@skynet.be>
Cc: pgsql-sql@postgresql.org
Subject: Re: select using regexp does not use indexscan
In-Reply-To: <3a0a211c.0411091202.223f1c02@posting.google.com>
Message-ID: <20041113133651.A44723@megazone.bigpanda.com>
References: <3a0a211c.0411091202.223f1c02@posting.google.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200411/130
X-Sequence-Number: 19449


On Tue, 9 Nov 2004, carex wrote:

> And it works also perfectly with Gentoo.
>
> So,is this a typical "Redhat Enterprise" problem ?
> Or do I overlook something ??

IIRC, in 7.3.x, index scans are only considered in "C" locale for
regexp/LIKE. In 7.4.x, non-"C" locale databases can use a special
index of a different opclass (<typename>_pattern_ops I believe).