Re: [GENERAL] How to create a multi-column index with 2 dates using 'gist'?

2009-08-26 Thread Jeff Davis
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

Re: [GENERAL] How to create a multi-column index with 2 dates using 'gist'?

2009-08-26 Thread Fred Janon
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

Re: [GENERAL] How to create a multi-column index with 2 dates using 'gist'?

2009-08-26 Thread Gerhard Heift
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

Re: [GENERAL] How to create a multi-column index with 2 dates using 'gist'?

2009-08-25 Thread Sam Mason
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

Re: [GENERAL] How to create a multi-column index with 2 dates using 'gist'?

2009-08-25 Thread Fred Janon
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

Re: [GENERAL] How to create a multi-column index with 2 dates using 'gist'?

2009-08-25 Thread Sam Mason
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

[GENERAL] How to create a multi-column index with 2 dates using 'gist'?

2009-08-24 Thread Fred Janon
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