Indexes

Primoz <primoz@slo-tech.com>

From: Primoz <primoz@slo-tech.com>
To: pgsql-general@postgresql.org
Date: 2004-08-20T03:31:36Z
Lists: 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