pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Karl Vogel <karl.vogel@telenet.be>
To: Yann Michel <yann-postgresql@spline.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Why so much time difference with a same query/plan?
Date: Sun, 26 Dec 2004 13:30:15 +0100
Message-ID: <m3y8flkzs8.fsf@telenet.be> (raw)
In-Reply-To: <20041223070453.GA30031@zong.spline.inf.fu-berlin.de>
References: <20041222200904.94015.qmail@web13124.mail.yahoo.com>
	<20041222215240.12345.qmail@web13124.mail.yahoo.com>
	<20041223070453.GA30031@zong.spline.inf.fu-berlin.de>

Yann Michel <yann-postgresql@spline.de> writes:

> On Wed, Dec 22, 2004 at 01:52:40PM -0800, Litao Wu wrote:
>> Does the order of columns in the index matter since
>> more than 50% customer_id = 158?
>> 
>> I think it does not in Oracle.
>> 
>> Will the performance be better if I change index
>> xxx_idx to ("domain", customer_id, created)?
>
> Well, in Oracle this would of cause matter. Oracle calculates index
> usage by being able to fill all index's attributes from the left to the
> right. If any one attribute within is missing Oracle would not test if
> it is only one attribute missing, or if all other attributes are missing
> within the query's where clause. 

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?



view thread (5+ messages)  latest in thread

Message-ID: <m3y8flkzs8.fsf@telenet.be>
Permalink:  ../m3y8flkzs8.fsf@telenet.be/
Also on:    postgresql.org/message-id/m3y8flkzs8.fsf@telenet.be

 · 

reply

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: karl.vogel@telenet.be, yann-postgresql@spline.de
  Subject: Re: Why so much time difference with a same query/plan?
  In-Reply-To: <m3y8flkzs8.fsf@telenet.be>

* 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