Re: Multiple Order By Criteria

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: J(at)planeti(dot)biz
Subject: Re: Multiple Order By Criteria
Date: 2006-01-17 22:25:38
Message-ID: 200601171425.38772.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-01-17 22:28:12 Re: Autovacuum / full vacuum
Previous Message J 2006-01-17 22:03:27 Multiple Order By Criteria