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