I meant that i have an index on pid and one on crit.
>>> "A. Kretschmer" <[EMAIL PROTECTED]> 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
