-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 03/20/07 14:11, Jonathan Vanasco wrote: > > 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. If the WHERE clause filters out most of the records, having ID in the index shouldn't be needed. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGADVyS9HxQb37XmcRAjJZAKCX1VmuSVdS9VfK6mXrYNl7mVATjQCgpWef MVFm2rH8+paCqnzyw9NyKZk= =kbvB -----END PGP SIGNATURE-----
