Re: slow UNIONing - Mailing list pgsql-hackers

From Kovacs Zoltan
Subject Re: slow UNIONing
Date
Msg-id Pine.LNX.4.21.0109210850090.8015-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
In response to Re: slow UNIONing  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
> > 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?
> 
> If you know, that your result does not produce duplicates
> (which are filtered away with "union") you can use a 
> "union all" which should be substantially faster, since it does 
> not need to sort.

Thank you to all who helped. I knew nothing about UNION ALL, but now it's
OK. Regards, Zoltan



pgsql-hackers by date:

Previous
From: Karel Zak
Date:
Subject: Re: PostgreSQL funding/organization
Next
From: Karel Zak
Date:
Subject: Re: Multibyte regression tests broken?