| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Fred Janon <fjanon(at)gmail(dot)com> |
| Cc: | Gerhard Heift <ml-postgresql-20081012-3518(at)gheift(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to create a multi-column index with 2 dates using 'gist'? |
| Date: | 2009-08-26 20:16:29 |
| Message-ID: | 1251317789.14504.1228.camel@monkey-cat.sm.truviso.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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 of any problems with
it." Right now all it does is implement the PERIOD data type, which is
indexable so that you can do searches on predicates like
"&&" (overlaps).
It may get a little more exciting when more features like temporal keys
(which I'm planning to make possible in the next commitfest) or temporal
joins (no serious plans yet, but seems doable) are implemented.
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | geoff | 2009-08-26 21:43:12 | Re: PG 8.2 instal on Win2k3 - unable to connect to test network socket |
| Previous Message | Bill Bartlett | 2009-08-26 20:09:32 | Re: Import data from XML file |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2009-08-26 20:42:35 | Re: Performance issues with large amounts of time-series data |
| Previous Message | Tom Lane | 2009-08-26 18:52:14 | Re: Performance issues with large amounts of time-series data |