Re: Seq scan of table?

> "Bjorn T Johansen" <btj@havleik.no> writes:
>> I am trying to tune my database and I discovered one select that does a
>> seq scan on a table but I can't see why... All the join fields are
>> indexed
>> and I am returning just one record, so no sort is done.
>> Does it just pick seq scan for the heck of it or is it a reason?
>
> Who's to say, when you gave us no details?  Show us the table schemas,
> the exact query, and EXPLAIN ANALYZE output, and you might get useful
> responses.
>
> (btw, pgsql-performance would be a more appropriate list for this issue
> than pgsql-general.)
>
>             regards, tom lane
>

Well, since the select involves 10-12 tables and a large sql, I just
thought I would try without all that information first... :)

And yes, pgsql-performance sounds like the right list....


BTJ