Re: Incorrect index being used - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Incorrect index being used
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17C28C7E@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Re: Incorrect index being used  (Jesse Long <jpl@unknown.za.net>)
Responses Re: Incorrect index being used
Re: Incorrect index being used
List pgsql-general
Jesse Long wrote:
> There is no problem with row visibility, there is only one connection to
> the database - the connection I am using to do these selects.

No idea why the plans cannot be used.

It might be helpful to see the table and index definitions.

> Thanks you for the advise regarding ANALYZE. I ran ANALYZE on both
> tables concerned, but not much changed:

Did you try increasing default_statistics_target before ANALYZE?

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Jov
Date:
Subject: Re: no syntax error on limit1
Next
From: janek12@web.de
Date:
Subject: Re: pg_similarity