Re: Index usage with slow query

Bill Moran wrote
> On Fri, 25 Jul 2014 17:20:57 +0100
> Rebecca Clarke <

> r.clarke83@

> > wrote:
>
> Note that this is speculation on my part, but the
> point being that if those columns are usually as narrow as your
> examples you might want to try changing them to VARCHAR(50) or
> something and see if the planner is more willing to use the
> indexes at that point.
>
> A lot of this is pure speculation on my part ... hope that it's
> helpful and doesn't lead you in the wrong direction.

The presence of absence of the length limiter on a varchar will not impact
the query plan.  And I'm pretty sure you cannot even store a too long
varchar in an index.  It will error on the attempt (as opposed to
truncating).

David J.






--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Index-usage-with-slow-query-tp5812503p5812862.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.