On 2021-02-25 14:52:20 -0500, Rumpi Gravenstein wrote:
> My use case involves complicated joins on source tables in one schema loading a
> target table in the same or a different schema.
So source(s) and target are in the same database? That wasn't clear from
your earlier mails.
If you are doing "complicated joins on source tables" that's probably
where the bottleneck will be, so you shouldn't worry about the insert
speed unless (or until) you notice that the bottleneck is writing the
data, not reading it.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp@xxxxxx | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
Attachment:
signature.asc
Description: PGP signature
