Re: Partial indices

Ferruccio Zamuner wrote:
>
> Hi all,
>
> I was reading the PostgreSQL manual when I found the Partial indices' page.
> I've read that partial indices are supported by PostgreSQL, but I've not
> found any example about how to construct them.
>
> I've check for create index documentation but I've not found any particular
> form dedicated to partial indices.
>
> Are Partial Indices still supported into latest release of PostgreSQL?
> If yes, how can I use of them?

I think they have suffered some serious bit-rot over the years
and are no longer functional, although some of the core code
still exists in the backend. It seems without bitmapped-indexes,
and the current state of partial indices, its impossible to index
on rare-occuring instances of an attribute against otherwise
regularly occuring data. :-(

Hope that helps,

Mike Mascari