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

Re: Why so much time difference with a same query/plan?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Karl Vogel <karl(dot)vogel(at)telenet(dot)be>
Cc: Yann Michel <yann-postgresql(at)spline(dot)de>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Why so much time difference with a same query/plan?
Date: 2004-12-31 06:10:42
Message-ID: 20041231061042.GA17555@wolff.to (view raw or flat)
Thread:
Lists: pgsql-performance
On Sun, Dec 26, 2004 at 13:30:15 +0100,
  Karl Vogel <karl(dot)vogel(at)telenet(dot)be> wrote:
> 
> This depends on the version of Oracle you're using. Oracle 9i 
> introduced Index Skip Scans:
> 
>  http://www.oracle.com/technology//products/oracle9i/daily/apr22.html
> 
> I don't know whether pg has something similar?

Postgres doesn't currently do this. There was some discussion about this
not too long ago, but I don't think anyone indicated that they were going to
work on it for 8.1.

Postgres can use the leading part of a multikey index to start a scan,
but it will just do a normal index scan with a filter.

In response to

pgsql-performance by date

Next:From: amritDate: 2005-01-02 02:54:32
Subject: Low Performance for big hospital server ..
Previous:From: Vishal Kashyap @ [SaiHertz]Date: 2004-12-31 05:48:02
Subject: Optimization while compiling

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