Skip site navigation (1) Skip section navigation (2)


From: Primoz <primoz(at)slo-tech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Indexes
Date: 2004-08-20 03:31:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

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 

Any suggestions?



pgsql-general by date

Next:From: Hunter HillegasDate: 2004-08-20 04:59:23
Subject: Re: Postgres and JBOSS
Previous:From: Tom LaneDate: 2004-08-20 03:16:32
Subject: Re: Indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group