Re: multiple table scan performance

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Samuel Gendler <sgendler(at)ideasculptor(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: multiple table scan performance
Date: 2011-03-29 22:28:07
Message-ID: AANLkTikeXoo4ZRRvLjx23sR1bNSqC9bevA5Cm9iKdvcU@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Mar 29, 2011 at 7:16 PM, Samuel Gendler
<sgendler(at)ideasculptor(dot)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 ...)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Craig James 2011-03-29 23:31:26 Re: multiple table scan performance
Previous Message Samuel Gendler 2011-03-29 22:16:19 multiple table scan performance