Help with performance - No2 - Mailing list pgsql-general

From Uros Gruber
Subject Help with performance - No2
Date
Msg-id 12107767170.20020424225125@sir-mag.com
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Uros Gruber
Date:
Subject: Help with performance
Next
From: tom dyson
Date:
Subject: Re: [pgsql-general] Daily Digest V1 #1617