Re: What O/S or hardware feature would be useful for databases? - Mailing list pgsql-general

From Alexander Staubo
Subject Re: What O/S or hardware feature would be useful for databases?
Date
Msg-id 88daf38c0706161620m1c084a13i6b3919b7e4333f0d@mail.gmail.com
Whole thread Raw
In response to Re: What O/S or hardware feature would be useful for databases?  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
On 6/17/07, Ron Johnson <ron.l.johnson@cox.net> wrote:
> On 06/16/07 17:05, Alexander Staubo wrote:
> > On 6/16/07, Ron Johnson <ron.l.johnson@cox.net> wrote:
> >> > Hardware acceleration for quickly counting the number of
> >> > set/unset/matching bits?
> >>
> >> x86 doesn't already do that?
> >
> > I don't think so. The fastest way, I believe, is to use precomputed
> > lookup tables. Same for finding the least/most significant set/unset
> > bit, and other operations useful for dealing with bit vectors.
>
> A couple of new AMD Barcelona opcodes might help do that:
>
> http://www.anandtech.com/showdoc.aspx?i=2939&p=6

Very cool. Thanks for the pointer.

Alexander.

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: What O/S or hardware feature would be useful for databases?
Next
From: "Leif B. Kristensen"
Date:
Subject: Re: PHP sucks!! - was: persistent db connections in PHP