Re: queries stop using indexes

On Apr 2, 2007, at 7:40 AM, Ragnar wrote:

> if you analyze the table after recreating the index, does it then stop
> using it?
>
> possibly you need to increase statistic targets on some or all
> of the index columns.
>
> a EXPLAIN ANALYZE could help figuring this out.

no, analyzing the virgin index is fine.

heavy use on the index just seems to convince the planner to not use
it -- and no amount of analyze or vaccum analyze will change that.

i'll post some verbose debugging on the queries and analyze the next
time the index blows




// Jonathan Vanasco

| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| SyndiClick.com
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
|      FindMeOn.com - The cure for Multiple Web Personality Disorder
|      Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
|      RoadSound.com - Tools For Bands, Stuff For Fans
|      Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -