Re: slow UNIONing - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: slow UNIONing
Date
Msg-id Pine.LNX.4.30.0109191221210.1053-100000@peter.localdomain
Whole thread Raw
In response to slow UNIONing  (Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>)
List pgsql-hackers
Kovacs Zoltan writes:

> I experienced that UNIONs in 7.1.1 are rather slow:
>
> tir=# explain (select nev from cikk) union (select tevekenyseg from log);

Try UNION ALL.  Plain UNION will eliminate duplicates, so it becomes
slower.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: Haller Christoph
Date:
Subject: Where are the ERROR: Messages
Next
From: Tom Lane
Date:
Subject: Re: Beta time