[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Antw: Re: Antw: Re: [GENERAL] Query questions
From:       "Christian Rengstl" <Christian.Rengstl () klinik ! uni-regensburg ! de>
Date:       2006-07-31 15:43:14
Message-ID: 44CE4132020000800004034D () rrzgw1 ! uni-regensburg ! de
[Download RAW message or body]

I meant that i have an index on pid and one on crit.


>>> "A. Kretschmer" <andreas.kretschmer@schollglas.com> 31.07.06 17.16
Uhr >>>
am  31.07.2006, um 15:55:39 +0100 mailte Richard Huxton folgendes:
> Christian Rengstl wrote:
> >My version is 8.1.4. Here is the plan for the query, it's performed
on a
> >                                    Total runtime: 1903.894 ms
> >And yes i have indexes on both pid (varchar(15)) and
crit(varchar(13)).
> 
> That's not quite what Andreas asked. Do you have an index on (pid,
crit)?

He has 8.1, and i think, we have bitmap index scan for such tasks...
(we don't need a index over both columns)

Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    === 

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
[prev in list] [next in list] [prev in thread] [next in thread]