Hi,
Isn't it much faster if you extract a substring from the date field?
For example if the date field returns 2001/12/30, you could use the 4th and
5th position for the month part.
regards,
freek
Tom Lane wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>