Matthew Wakeling <matt...@flymine.org> wrote: > any other tips? I would try adding an index on (objectid, start) and another on (objectid, end) and see how that first query does. Also, if id is a unique identifier, I'd recommend a unique constraint or (better) a primary key definition. Check the system tables to see whether all the existing indexes are actually being used -- if not, drop them. -Kevin
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance