| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Antw: Re: Query questions |
| Date: | 2006-07-31 15:16:32 |
| Message-ID: | 20060731151632.GA1596@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Rengstl | 2006-07-31 15:43:14 | Antw: Re: Antw: Re: Query questions |
| Previous Message | DANTE Alexandra | 2006-07-31 15:00:55 | Re: Questions about update, delete, ctid... |