Re: Seq Scan

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)
>

In response to

  • Seq Scan at 2001-05-28 16:23:36 from Linh Luong

Browse pgsql-general by date

  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