From: Tarabas (Manuel Rorarius) <tarabas@tarabas.de>
To: Dave Dutcher <dave@tridecap.com>
To: pgsql-performance@postgresql.org
Subject: Re: Problem with LIKE-Performance
Date: Tue, 18 Apr 2006 17:16:18 +0200
Message-ID: <1043488152.20060418171618@tarabas.de> (raw)
In-Reply-To: <001a01c662f9$f2449f00$8300a8c0@tridecap.com>
References: <341367953.20060418163513@tarabas.de>
<001a01c662f9$f2449f00$8300a8c0@tridecap.com>
Hi Dave,
DD> It looks like you are getting a sequential scan instead of an index
DD> scan. What is your locale setting? As far as I know Postgres doesn't
DD> support using indexes with LIKE unless you are using the C locale.
Actually no, I am using de_DE as locale because I need the german
order-by support. But even for a seq-scan it seems pretty slow, but that's
just a feeling. The table currently has ~172.000 rows and is suposed to
rise to about 1 mio or more.
Is there any way to speed the like's up with a different locale than C
or to get an order by in a different Locale although using the
default C locale?
DD> Also, in the future you only need to post EXPLAIN ANALYZE not EXPLAIN
DD> ANALYZE VERBOSE.
ok, i will keep that in mind :-) didn't know how verbose you would need
it *smile*
Best regards
Manuel
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: tarabas@tarabas.de, dave@tridecap.com
Subject: Re: Problem with LIKE-Performance
In-Reply-To: <1043488152.20060418171618@tarabas.de>
* 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