Re: Fwd: increase insert into local table from remote oracle table preformance

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fwd: increase insert into local table from remote oracle table preformance
Date: 2018-08-15 20:26:56
Message-ID: 1534364816094-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

This is not so bad, you where at 10h for 200GB (20GB/h),
And now at 24GB/h, it makes a 20% increase ;0)

Could you tell us what are the résults with parallel exécutions
(Before to switch to unload reload strategy)

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2018-08-15 20:28:20 Re: How to revoke privileged from PostgreSQL's superuser
Previous Message Bruce Momjian 2018-08-15 20:26:46 Re: How to revoke privileged from PostgreSQL's superuser

Browse pgsql-performance by date

  From Date Subject
Next Message Sand Stone 2018-08-15 20:32:45 Re: dsa_allocate() faliure
Previous Message Reza Taheri 2018-08-15 20:03:00 RE: Calculating how much redo log space has been used