Matthew Wakeling <matthew(at)flymine(dot)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.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2009-03-26 15:49:42|
|Subject: Re: Very specialised query |
|Previous:||From: Matthew Wakeling||Date: 2009-03-26 14:30:55|
|Subject: Very specialised query|