outer joins take forever

Поиск
Список
Период
Сортировка
От spivey_seth@yahoo.com (Seth)
Тема outer joins take forever
Дата
Msg-id ced533a.0105310826.5ad5eb66@posting.google.com
обсуждение исходный текст
Ответы Re: outer joins take forever  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
Список pgsql-general
I'm attempting to do an OUTER JOIN of two tables

    neicstats    (6841 rows)
    customer    (5062 rows)

I'm using the command

select * from neicstats left outer join customer on (
neicstats.cli_num = customer.cust_no );

which seems to run forever.

I've created indexes on both cli_num and cust_no but 'explain' seems
to indicate they're not being used -

explain select * from neicstats left outer join customer on (
neicstats.cli_num = customer.cust_no );
NOTICE:  QUERY PLAN:

Nested Loop  (cost=0.00..2297525.72 rows=285698 width=532)
  ->  Seq Scan on neicstats  (cost=0.00..206.87 rows=6687 width=140)
  ->  Seq Scan on customer  (cost=0.00..267.62 rows=5062 width=392)

What methods can I use to speed up this query?  Why does it take so
long?

В списке pgsql-general по дате отправления:

Предыдущее
От: mordicus
Дата:
Сообщение: Re: Vacuum problem on large table
Следующее
От: "Steve Wolfe"
Дата:
Сообщение: Re: Now what?