| From: | Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> |
|---|---|
| To: | Zeugswetter Andreas SB SD <ZeugswetterA(at)spardat(dot)at> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: slow UNIONing |
| Date: | 2001-09-21 06:50:57 |
| Message-ID: | Pine.LNX.4.21.0109210850090.8015-100000@pc10.radnoti-szeged.sulinet.hu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2001-09-21 08:00:30 | Re: PostgreSQL funding/organization |
| Previous Message | Thomas Lockhart | 2001-09-21 05:04:19 | Re: [PATCH] [LARGE] select * from cursor foo |