Re: Sequencial scan instead of using index issue again

From: Greg Stark <gsstark(at)mit(dot)edu>
To: "Harry Hehl" <Harry(dot)Hehl(at)diskstream(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Sequencial scan instead of using index issue again
Date: 2006-03-07 06:30:45
Message-ID: 87pskyojfu.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Harry Hehl" <Harry(dot)Hehl(at)diskstream(dot)com> writes:

> I am having an issue with a joins. I am using 8.0.3 on FC4
>
> Query: select * from ommemberrelation where srcobj='somevalue' and dstobj in
> (select objectid from omfilesysentry where name='dir15_file80');
>
> PLAN
...
> (29 rows)

That plan doesn't correspond to the query you posted. Try sending the result
of EXPLAIN ANALYZE from the actual query or else posting the actual query
you're running.

--
greg

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Newman 2006-03-07 06:34:33 Triggers and Multiple Schemas.
Previous Message Michael Fuhr 2006-03-07 06:28:30 Re: is it possible to get current_user inside security definer function ?