Hi All,<br /><br />I'm having very strange problems with indexing, I have a large number of partial indexes, when i try
torun some queries sometimes the queries run very fast and sometimes they are 100times slower than what i ran
before.....Itried running vacuum analyze couple of times and it dint help me at all. Also i tried the explain analyze
andwhat i found was the query execution plan keeps on changes. Is there any better way to gain control over these, I
triedturning seqscan off, and messing with some other parameters but dint really help. Also can somebody point me out
tolinks which explains more about query execution plans..i.e. each of parameters like bitmap heap scan, index
scan....etc...<br /><br />-- <br />Thanks,<br />Sumeet