Postgres Pro
Downloads
Home   >   mailing lists

Re: query plan with index having a btrim is different for strings of different length - Mailing list pgsql-performance

From Robert Haas
Subject Re: query plan with index having a btrim is different for strings of different length
Date
Msg-id 603c8f070812101139p189cc828hef8702f37f952b6d@mail.gmail.com
Whole thread Raw
In response to Re: query plan with index having a btrim is different for strings of different length  (Richard Yen <dba@richyen.com>)
Responses Re: query plan with index having a btrim is different for strings of different length  (Richard Yen <dba@richyen.com>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: query plan with index having a btrim is different for strings of different length
Next
From: "Scott Marlowe"
Date:
Subject: Re: Experience with HP Smart Array P400 and SATA drives?