On Mar 20, 2:54 pm, [EMAIL PROTECTED] (Jonathan Vanasco) wrote: > can anyone suggest an indexing approach that might get pg to use the > indexes ? this is driving me crazy.
Have you tried an expression-based index? http://www.postgresql.org/docs/8.1/interactive/indexes-expressional.html I'm assuming the right side of each equals sign is constant for you. Basically, you could create an expression-based index on all these conditions, which would evaluate to true or false for every row in your table. Caveat: If you have heavy updates/inserts this might be a bad idea. Also, the planner may still decide to seq scan, based on your configuration and resultset size. Mark ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
