On Mar 20, 2007, at 2:54 PM, Jonathan Vanasco wrote:
> No matter how I index + analyze this table, including making an
> index of every related column on the search, pg keeps doing a
> sequential scan and never includes an index -- which takes
> ~2minutes to do. I really need to cut this down.
a friend just chimed in off-list -- i had missed putting the 'id'
column in the large index of all the used columns , a common
mistake. works like a charm now.