Re: [HACKERS] slow UNIONing

[Peter Eisentraut]

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   [EMAIL PROTECTED]   http://funkturm.homeip.net/~peter


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org