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

IN + index

From: Enrico Weigelt <weigelt(at)metux(dot)de>
To: pgsql-de-allgemein <pgsql-de-allgemein(at)postgresql(dot)org>
Subject: IN + index
Date: 2005-11-04 15:10:47
Message-ID: 20051104151047.GA23362@nibiru.local (view raw or flat)
Thread:
Lists: pgsql-de-allgemein
moin,

kann es sein, daß Indices bei IN-Operationen nicht greifen ?
Ich hatte grad in einem Trigger das Phenomen, daß bei einem 

    WHERE id IN ( OLD.a, OLD.b )
    
extrem lange dauerte - schein in einem sequentiellen scan zu enden.

(Habs ehrlichgesagt noch nicht separat analysieren lassen..)


cu
-- 
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service
  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     contact(at)metux(dot)de
---------------------------------------------------------------------
  Realtime Forex/Stock Exchange trading powered by postgreSQL :))
                                            http://www.fxignal.net/
---------------------------------------------------------------------

Responses

pgsql-de-allgemein by date

Next:From: Andreas KretschmerDate: 2005-11-04 18:46:05
Subject: Re: IN + index
Previous:From: Christian FröseDate: 2005-11-04 13:07:34
Subject: Re: Fe

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