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
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
