From: | "Dave Cramer" <Dave(at)micro-automation(dot)net> |
---|---|
To: | "Linh Luong" <linh(dot)luong(at)computalog(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Seq Scan |
Date: | 2001-05-28 17:08:23 |
Message-ID: | 029801c0e798$cd8c1990$230470d1@INSPIRON |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can you send the relevant tables, indexes, and query
--dc--
----- Original Message -----
From: "Linh Luong" <linh(dot)luong(at)computalog(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Monday, May 28, 2001 12:23 PM
Subject: [GENERAL] Seq Scan
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-28 17:35:43 | Re: restore pg_dumpall problem with update 7.0.3 to 7.1.1 |
Previous Message | Linh Luong | 2001-05-28 16:23:36 | Seq Scan |