Re: Can this query be optimized?

Claus Heiko Niesen <cniesen@gmx.net> writes:
> I'm stuck optimizing the following query:
> select distinct extract(year from date) as year, extract(month from date) 
> as month, date from week_pics order by date desc;

Perhaps it would work to forget the "distinct" and instead GROUP BY
date.
        regards, tom lane