Postgres Pro
Downloads
Home   >   mailing lists

Re: force the use of a particular index - Mailing list pgsql-performance

From Tom Lane
Subject Re: force the use of a particular index
Date
Msg-id 12043.1057938267@sss.pgh.pa.us
Whole thread Raw
In response to Re: force the use of a particular index  (Scott Cain <cain@cshl.org>)
List pgsql-performance
Tree view 
Scott Cain <cain@cshl.org> writes:
> Embarrassingly, I can't.  I've been monkeying with the database so much
> that I can't seem to get it back to the state where I reproduce the
> behavior I want.

If the thing works as desired after a VACUUM ANALYZE, then I suggest
the estimation failure was just due to out-of-date statistics ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Scott Cain
Date:
Subject: Re: force the use of a particular index
Next
From: "Nikolaus Dilger"
Date:
Subject: Re: Dual Xeon + HW RAID question