Indexes - Mailing list pgsql-general

From Primoz
Subject Indexes
Date
Msg-id 200408200531.38187.primoz@slo-tech.com
Whole thread Raw
Responses Re: Indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello,

is there any way to speedup queryes like

select ... from [table a] where [int field b] = [number] order by [datetime
field c] desc limit [number];

with index on field b I get something, but pgsql afterwards resolves to
sorting manually.

partial indices with index on field c where field b = number works, but are
dirty and are becoming annoying as number of different values of field b
grows.

Any suggestions?

Primoz

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.0 release schedule?
Next
From: Tom Lane
Date:
Subject: Re: Indexes