Re: Very specialised query - Mailing list pgsql-performance

From Marc Mamin
Subject Re: Very specialised query
Date
Msg-id C4DAC901169B624F933534A26ED7DF311F9C08@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to Very specialised query  (Matthew Wakeling <matthew@flymine.org>)
Responses Re: Very specialised query  (Matthew Wakeling <matthew@flymine.org>)
List pgsql-performance

Hello Matthew,

Another idea:

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...

Marc Mamin

pgsql-performance by date:

Previous
From: Віталій Тимчишин
Date:
Subject: Re: Very specialised query
Next
From: dan@sidhe.org
Date:
Subject: Trying to track down weird query stalls