Re: Performance question - Mailing list pgsql-general

From Tille, Andreas
Subject Re: Performance question
Date
Msg-id Pine.LNX.4.33.0109111358040.4709-100000@wr-linux02.rki.ivbb.bund.de
Whole thread Raw
In response to Re: Performance question  (Einar Karttunen <ekarttun@cs.Helsinki.FI>)
List pgsql-general
On Mon, 10 Sep 2001, Einar Karttunen wrote:

> ...
> temp=# CREATE INDEX hfia ON Hauptdaten_Fall (IstAktuell);
> CREATE
> temp=# explain SELECT MeldeKategorie,count(ID) FROM Hauptdaten_Fall
> temp-#  WHERE IstAktuell=20 GROUP BY MeldeKategorie
> temp-#  ORDER BY MeldeKategorie;
> NOTICE:  QUERY PLAN:
>
> Aggregate  (cost=8.30..8.35 rows=1 width=16)
>   ->  Group  (cost=8.30..8.33 rows=10 width=16)
>         ->  Sort  (cost=8.30..8.30 rows=10 width=16)
>               ->  Index Scan using hfia on hauptdaten_fall  (cost=0.00..8.14 rows=10 width=16)
>
Thanks for the hint but the index exists but is not used (see my previous
mail with a detailed description).

Kind regards

       Andreas.

pgsql-general by date:

Previous
From: "Tille, Andreas"
Date:
Subject: Re: Performance question
Next
From: Culley Harrelson
Date:
Subject: Re: Fwd: Re: unicode in 7.1