From: Dave Dutcher <dave@tridecap.com>
To: 'Tarabas \(Manuel Rorarius\)' <tarabas@tarabas.de>
To: pgsql-performance@postgresql.org
Subject: Re: Problem with LIKE-Performance
Date: Tue, 18 Apr 2006 10:08:27 -0500
Message-ID: <001a01c662f9$f2449f00$8300a8c0@tridecap.com> (raw)
In-Reply-To: <341367953.20060418163513@tarabas.de>
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-
> owner@postgresql.org] On Behalf Of Tarabas (Manuel Rorarius)
> Subject: [PERFORM] Problem with LIKE-Performance
>
> Hi!
>
> I am having trouble with like statements on one of my tables.
It looks like you are getting a sequential scan instead of an index
scan. What is your locale setting? As far as I know Postgres doesn't
support using indexes with LIKE unless you are using the C locale.
Also, in the future you only need to post EXPLAIN ANALYZE not EXPLAIN
ANALYZE VERBOSE.
Dave
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dave@tridecap.com, tarabas@tarabas.de
Subject: Re: Problem with LIKE-Performance
In-Reply-To: <001a01c662f9$f2449f00$8300a8c0@tridecap.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox