On Mon, 30 Mar 2009, Marc Mamin wrote:
Are your objects limited to some smaller ranges of your whole interval ? If yes you may possibly reduce the ranges to search for while using an additional table with the min(start) max(end) of each object...
No, they aren't. However, even if they were, that would not actually speed up the query at all. We are already looking up in the index by objectid, and that would be an equivalent constraint to limiting by the available range of start/end values.
I'm currently arguing with plpgsql over this problem, but it looks like it will run reasonably fast.
Matthew -- If you're thinking "Oh no, this lecturer thinks Turing Machines are a feasible method of computation, where's the door?", then you are in luck. There are some there, there, and by the side there. Oxygen masks will not drop from the ceiling... -- Computer Science Lecturer -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
