From: Robert Haas <robertmhaas@gmail.com>
To: Richard Yen <dba@richyen.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: query plan with index having a btrim is different for strings of different length
Date: Wed, 10 Dec 2008 14:39:42 -0500
Message-ID: <603c8f070812101139p189cc828hef8702f37f952b6d@mail.gmail.com> (raw)
In-Reply-To: <E8AE9590-4E30-49C0-B11F-D7131009A095@richyen.com>
References: <751F49DC-1142-4E9C-95C8-BC3C229B3F0B@richyen.com>
<22937.1228865243@sss.pgh.pa.us>
<E8AE9590-4E30-49C0-B11F-D7131009A095@richyen.com>
> You guys are right. I tried "Miller" and gave me the same result. Is there
> any way to tune this so that for the common last names, the query run time
> doesn't jump from <1s to >300s?
> Thanks for the help!
Can you send the output of EXPLAIN ANALYZE for both cases?
...Robert
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: robertmhaas@gmail.com, dba@richyen.com, tgl@sss.pgh.pa.us
Subject: Re: query plan with index having a btrim is different for strings of different length
In-Reply-To: <603c8f070812101139p189cc828hef8702f37f952b6d@mail.gmail.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