| From: | "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Postgres Analog of Oracle APPEND hint |
| Date: | 2021-03-05 15:10:12 |
| Message-ID: | 20210305151012.GA13266@hjp.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2021-03-05 17:36:37 | Re: Log files polluted with permission denied error messages after every 10 seconds |
| Previous Message | Laurenz Albe | 2021-03-05 13:50:07 | Re: Log files polluted with permission denied error messages after every 10 seconds |