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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
