On 12/18/2011 1:31 PM, Tom Lane wrote:
If you have a specific case where that's not true, you might consider a partial index (CREATE INDEX ... WHERE x <> constant). But the details of that would depend a lot on the queries you're concerned about. regards, tom lane
Which I had tried in the form of (st_geometrytype(location) <> 'ST_Point'::text)... planner never picked it (for the scenario given before). But this thread was all pretty much .. design/plan/future use. This specific instance I've handled with in ("ST_Polygon","ST_MultiPolygon").
Thank you for the feedback. Roxanne -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
