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.
