Josh,
> > So why did were the indices not used before when they yield
> a better plan?
>
> Your .conf settings, most likely. I'd lower your
> random_page_cost and raise
> your effective_cache_size.
Increasing effective_cache_size to 10000 did it. The query now
takes 4 secs. I left random_page_cost at the default value of 4.
I thought, mistakenly apparently, that our database was relatively
itty bitty and so haven't messed with the .conf file. Guess I
better take a look at all the settings (I know where the docs are).
Thanks for your help,
Medora
***********************************************************************
Medora Schauer
Sr. Software Engineer
Fairfield Industries
***********************************************************************
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
