Re: Serious Performance Loss in 7.0.2??

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