On Wed, 2009-08-26 at 23:08 +0800, Fred Janon wrote:
> Thanks Gerhard, interesting but I wonder if it is a maintained
> project, the files date from May 2008 and there is not much forum
> activity. I'll out it on my list of "To be investigated".
Well, it's maintained in the sense of "I don't know
Thanks Gerhard, interesting but I wonder if it is a maintained project, the
files date from May 2008 and there is not much forum activity. I'll out it
on my list of "To be investigated".
Fred
On Wed, Aug 26, 2009 at 22:26, Gerhard Heift <
ml-postgresql-20081012-3...@gheift.de> wrote:
> But curre
On Mon, Aug 24, 2009 at 05:24:59PM +0800, Fred Janon wrote:
> Hi,
>
> I am using 8.3 and pgAdmin III. I have a couple of tables using 2 DATE columns
> like 'startdate' and 'enddate' (just date, not interested in time in these
> columns). I have some queries (some using OVERLAPS) involving both 'st
On Tue, Aug 25, 2009 at 07:39:26PM +0800, Fred Janon wrote:
> Basically I have an events table representing events with a duration
> (startdate, enddate). I was wondering if it would improve the performance if
> I was creating a separate table (indexed as you suggested) with the date
> ranges (star
Thanks Sam. I looked at the gist documentation and although it would be fun,
I don't have the time at the moment to explore that avenue (and scratching
my head!). I also think it would require a lot of work testing to validate
the code and that the gist index is better than the B-tree one. So I am
On Mon, Aug 24, 2009 at 05:24:59PM +0800, Fred Janon wrote:
> I am using 8.3 and pgAdmin III. I have a couple of tables using 2 DATE
> columns like 'startdate' and 'enddate' (just date, not interested in time in
> these columns). I have some queries (some using OVERLAPS) involving both
> 'startdate
Hi,
I am using 8.3 and pgAdmin III. I have a couple of tables using 2 DATE
columns like 'startdate' and 'enddate' (just date, not interested in time in
these columns). I have some queries (some using OVERLAPS) involving both
'startdate' and 'enddate' columns. I tried to create a multi column index