Tom Lane wrote:
> Also I'd suggest trying
>
> select year from [table] group by year
>
> which is capable of using a hash aggregation approach; that will likely
> beat either of these plans.
Just out of curiosity, why doesn't the planner consider the same plan
for the OP's original query:
select distinct year from [table]
Aren't these equivalent (except for the order)?
Thanks.
- John Burger