On Tue, Mar 29, 2011 at 7:16 PM, Samuel Gendler
<sgend...@ideasculptor.com> wrote:
> Is there any performance benefit to revamping the workload such that it issues
> a single:
> insert into (...) select ... UNION select ... UNION select
> as opposed to 3 separate "insert into () select ..." statements.

I wouldn't expect any difference - if you used UNION ALL (union will
be equivalent to insert into ()  select DISTINCT ...)

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to