Seq Scan - Mailing list pgsql-general

From Linh Luong
Subject Seq Scan
Date
Msg-id 3B127B88.D5A783A7@computalog.com
Whole thread Raw
List pgsql-general
Hi,

I am trying to execute this query I wrote and it is not returning at a
reasonable time to the browser.  I took the query and ran EXPLAIN on it
and it displayed that every JOIN I do it is doing a Seq Scan on it.  I
have indexes on that table but it doesn't seem to use it.

Is there a way I can ensure that postgres will use my indexes?

Thanks again


Linh

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: set datestyle
Next
From: Tom Lane
Date:
Subject: Re: set datestyle