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

Reply via email to