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

Indexes

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: 200408200531.38187.primoz@slo-tech.com (view raw or flat)
Thread:
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

Responses

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-2014 The PostgreSQL Global Development Group