Re: [HACKERS] Slow - grindingly slow - query

Hannu Krosing wrote:
> try using
>     create index registrationtype_index  on accounts (registrationtype);

OK did that, and am rerunning the query. 

The explain now shows
  explain select accountdetail.domain from accountdetail where
    accountdetail.domain not in
      (select accountmaster.domain from accountmaster);
  NOTICE:  QUERY PLAN:

  Seq Scan on accounts  (cost=3667.89 rows=34958 width=12)
    SubPlan
      ->  Index Scan using registrationtype_idx on accounts  (cost=2444.62
rows=33373 width=12)

  EXPLAIN


Will let you all know when it completes.
--------
Regards
Theo