slow UNIONing

Поиск
Список
Период
Сортировка
От Kovacs Zoltan
Тема slow UNIONing
Дата
Msg-id Pine.LNX.4.21.0109181548210.3295-100000@pc10.radnoti-szeged.sulinet.hu
обсуждение исходный текст
Ответы Re: slow UNIONing
Список pgsql-hackers
I experienced that UNIONs in 7.1.1 are rather slow:

tir=# explain (select nev from cikk) union (select tevekenyseg from log);
NOTICE:  QUERY PLAN:

Unique  (cost=667.63..687.18 rows=782 width=12) ->  Sort  (cost=667.63..667.63 rows=7817 width=12)       ->  Append
(cost=0.00..162.17rows=7817 width=12)             ->  Subquery Scan *SELECT* 1  (cost=0.00..28.16 rows=1316 width=12)
               ->  Seq Scan on cikk  (cost=0.00..28.16 rows=1316 width=12)             ->  Subquery Scan *SELECT* 2
(cost=0.00..134.01rows=6501 width=12)                   ->  Seq Scan on log  (cost=0.00..134.01 rows=6501 width=12)
 

Of course a simple SELECT is fast:

tir=# explain select nev from cikk;
NOTICE:  QUERY PLAN:

Seq Scan on cikk  (cost=0.00..28.16 rows=1316 width=12)


For me it seems to be slow due to the sorting. Is this right?
Is this normal at all? Is it possible to make it faster?

TIA, Zoltan

--                         Kov\'acs, Zolt\'an                        kovacsz@pc10.radnoti-szeged.sulinet.hu
          http://www.math.u-szeged.hu/~kovzol                        ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz
 



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

Предыдущее
От: Gunnar Rønning
Дата:
Сообщение: Re: Major change to CVS effective immediately ...
Следующее
От: "news.grapid1.mi.home.com"
Дата:
Сообщение: CVS access problem