On Wed, 12 Jul 2000, Tim Perdue wrote:
> 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.
Ouch! because of that query, or is this standard? what is the server,
anyway?
