From: Bruno Wolff III <bruno@wolff.to>
To: Karl Vogel <karl.vogel@telenet.be>
Cc: Yann Michel <yann-postgresql@spline.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Why so much time difference with a same query/plan?
Date: Fri, 31 Dec 2004 00:10:42 -0600
Message-ID: <20041231061042.GA17555@wolff.to> (raw)
In-Reply-To: <m3y8flkzs8.fsf@telenet.be>
References: <20041222200904.94015.qmail@web13124.mail.yahoo.com>
<20041222215240.12345.qmail@web13124.mail.yahoo.com>
<20041223070453.GA30031@zong.spline.inf.fu-berlin.de>
<m3y8flkzs8.fsf@telenet.be>
On Sun, Dec 26, 2004 at 13:30:15 +0100,
Karl Vogel <karl.vogel@telenet.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bruno@wolff.to, karl.vogel@telenet.be, yann-postgresql@spline.de
Subject: Re: Why so much time difference with a same query/plan?
In-Reply-To: <20041231061042.GA17555@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox