Help with performance - No2

From: Uros Gruber <uros(dot)gruber(at)sir-mag(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Help with performance - No2
Date: 2002-04-24 20:51:25
Message-ID: 12107767170.20020424225125@sir-mag.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

This is second mail, I send it to quickly

NOTICE: QUERY PLAN:

Nested Loop (cost=0.00..154844.08 rows=96 width=36)
-> Seq Scan on table1 d (cost=0.00..2957.36 rows=25236 width=28)
-> Index Scan using table1_pk on table2 c (cost=0.00..6.00 rows=1 width=8)

I see that there is seq scan over 25k rows, how can i set
indexes to make query faster and use indexes.

--
TIA,
Uros

Browse pgsql-general by date

  From Date Subject
Next Message Uros Gruber 2002-04-24 20:54:52 Speeding query
Previous Message Uros Gruber 2002-04-24 20:49:12 Help with performance