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

Re: Query composite index range in an efficient way

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: Havasvölgyi Ottó <havasvolgyi(dot)otto(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query composite index range in an efficient way
Date: 2009-02-17 13:10:11
Message-ID: 87wsbp1a6k.fsf@oxford.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-performance
Havasvölgyi Ottó <havasvolgyi(dot)otto(at)gmail(dot)com> writes:

> I also tried Row constructors with a Between expression, but in this case
> Postgres handled the elements of the row independently, and this led to
> false query result.

What version of Postgres is this? row constructors were fixed a long time ago
to not do that and the main benefit of that was precisely that this type of
expression could use a multi-column index effectively.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning

In response to

Responses

pgsql-performance by date

Next:From: Rajesh Kumar MallahDate: 2009-02-17 13:25:42
Subject: Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
Previous:From: Matthew WakelingDate: 2009-02-17 12:56:54
Subject: Re: Query composite index range in an efficient way

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