Lists: | pgsql-hackers |
---|
From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | Yann Michel <yann-postgresql(at)spline(dot)de> |
Subject: | Re: plans for bitmap indexes? |
Date: | 2004-10-08 16:59:41 |
Message-ID: | 200410080959.41632.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Yann,
> > Lots of people have talked about it but I don't know anyone coding it.
I would love to have bitmap indexes in Postgres, as would a lot of other
community members. However, they are far from trivial to code. Are you
offering to help?
--
Josh Berkus
Aglio Database Solutions
San Francisco
From: | Yann Michel <yann-postgresql(at)spline(dot)de> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: plans for bitmap indexes? |
Date: | 2004-10-08 17:10:53 |
Message-ID: | 20041008171053.GA11149@zoom.spline.inf.fu-berlin.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hi Josh,
On Fri, Oct 08, 2004 at 09:59:41AM -0700, Josh Berkus wrote:
>
> > > Lots of people have talked about it but I don't know anyone coding it.
>
> I would love to have bitmap indexes in Postgres, as would a lot of other
> community members. However, they are far from trivial to code. Are you
> offering to help?
I'd like to help you, but I think, that my C-Experience is not good
enough for beeing able to. I mean, I coded some C-stuff and I know how
bitmap indexes (should) work but I guess that this won't be enough. In
addidtion I never took a look into postgresql's sources.
Regards,
Yann
From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Yann Michel <yann-postgresql(at)spline(dot)de> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: plans for bitmap indexes? |
Date: | 2004-10-08 17:18:27 |
Message-ID: | 200410081018.27956.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Yann,
> I'd like to help you, but I think, that my C-Experience is not good
> enough for beeing able to. I mean, I coded some C-stuff and I know how
> bitmap indexes (should) work but I guess that this won't be enough. In
> addidtion I never took a look into postgresql's sources.
Well, there's no time like the present to get started! ;-)
--
Josh Berkus
Aglio Database Solutions
San Francisco
From: | Yann Michel <yann-postgresql(at)spline(dot)de> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: plans for bitmap indexes? |
Date: | 2004-10-08 19:13:36 |
Message-ID: | 20041008191336.GA11796@zoom.spline.inf.fu-berlin.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hi Josh,
On Fri, Oct 08, 2004 at 10:18:27AM -0700, Josh Berkus wrote:
>
> > I'd like to help you, but I think, that my C-Experience is not good
> > enough for beeing able to. I mean, I coded some C-stuff and I know how
> > bitmap indexes (should) work but I guess that this won't be enough. In
> > addidtion I never took a look into postgresql's sources.
>
> Well, there's no time like the present to get started! ;-)
O.K. I downloaded it :-)
We will see if and how I can help....
Regards,
Yann
From: | Sailesh Krishnamurthy <sailesh(at)cs(dot)berkeley(dot)edu> |
---|---|
To: | Yann Michel <yann-postgresql(at)spline(dot)de> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: plans for bitmap indexes? |
Date: | 2004-10-09 00:01:33 |
Message-ID: | mjqpt3src82.fsf@drones.CS.Berkeley.EDU |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
>>>>> "Yann" == Yann Michel <yann-postgresql(at)spline(dot)de> writes:
Yann> O.K. I downloaded it :-) We will see if and how I can
Yann> help....
FYI .. in case you aren't aware already:
http://portal.acm.org/citation.cfm?id=98720
--
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh
From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: plans for bitmap indexes? |
Date: | 2004-10-09 17:36:09 |
Message-ID: | 60zn2vvlo6.fsf@dba2.int.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
josh(at)agliodbs(dot)com (Josh Berkus) writes:
>> > Lots of people have talked about it but I don't know anyone coding it.
>
> I would love to have bitmap indexes in Postgres, as would a lot of other
> community members. However, they are far from trivial to code. Are you
> offering to help?
I'm curious as to whether partial indexes might suffice as an
alternative.
There are doubtless cases where the optimizer won't use them where it
would be plausible to do so; that suggests, to me, possibilities for
enhancing the optimizer.
--
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://www.ntlug.org/~cbbrowne/linuxxian.html
A VAX is virtually a computer, but not quite.
From: | Neil Conway <neilc(at)samurai(dot)com> |
---|---|
To: | Chris Browne <cbbrowne(at)acm(dot)org> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: plans for bitmap indexes? |
Date: | 2004-10-13 08:12:33 |
Message-ID: | 1097655153.30026.505.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Sun, 2004-10-10 at 03:36, Chris Browne wrote:
> There are doubtless cases where the optimizer won't use them where it
> would be plausible to do so; that suggests, to me, possibilities for
> enhancing the optimizer.
Speaking of which, if anyone has any examples of queries for which we
ought to be able to use a partial index but currently cannot, please
speak up (or mail me privately).
-Neil