Andrew McMillan wrote:
> PostgreSQL seems to not get the index choice right when you have index
> matches that are like =, =, =, DESC so you actually need to specify the
> ORDER BY clause in full like:
> ORDER BY mail_list DESC, mail_year DESC, mail_month DESC, mail_date
> DESC
> and things will hopefully be all OK again.
Wow - that definitely does *not* work. That took 1:30 to return the
result for the linux-kernel list.
My server has a load of 19.25 right now - at 6 AM.
Tim
--
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723