Re: Very specialised query

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: "Matthew Wakeling" <matthew(at)flymine(dot)org>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Very specialised query
Date: 2009-03-30 17:44:51
Message-ID: C4DAC901169B624F933534A26ED7DF311F9C08@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message dan 2009-03-30 17:50:52 Trying to track down weird query stalls
Previous Message Scott Marlowe 2009-03-30 16:25:36 Re: Forcing seq_scan off for large table joined with tiny table yeilds improved performance