Postgres Pro
Downloads
Home   >   mailing lists

Re: Multiple Order By Criteria - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Multiple Order By Criteria
Date
Msg-id 200601171425.38772.josh@agliodbs.com
Whole thread Raw
In response to Multiple Order By Criteria  (J@Planeti.Biz)
Responses Re: Multiple Order By Criteria  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-performance
Tree view 
J,

> I have an index built for each of these columns in my order by clause.
> This query takes an unacceptable amount of time to execute. Here are the
> results of the explain:

You need a single index which has all five columns, in order.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: J@Planeti.Biz
Date:
Subject: Multiple Order By Criteria
Next
From: J@Planeti.Biz
Date:
Subject: Re: Multiple Order By Criteria