gtakahashi(at)palantir(dot)com writes:
> Doing a select count(distinct column) does not utilize indices
Nope, it does not. Don't hold your breath waiting for that to change;
it might sometime, but nobody is working on it that I know of.
You'd have better luck with a "SELECT count(*) GROUP BY column"
type of query, I expect. (Most likely that won't use an index either,
BTW, but it'll be smarter than count(distinct).)
regards, tom lane