From: | "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de> |
---|---|
To: | <andreas(dot)kretschmer(at)schollglas(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Antw: Re: Antw: Re: Query questions |
Date: | 2006-07-31 15:43:14 |
Message-ID: | 44CE4132020000800004034D@rrzgw1.uni-regensburg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I meant that i have an index on pid and one on crit.
>>> "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Kastner | 2006-07-31 15:50:16 | pg_xlog not cleaned up |
Previous Message | A. Kretschmer | 2006-07-31 15:16:32 | Re: Antw: Re: Query questions |