Quick Links

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-13 21:03:58
Message-ID:	1534194238024-0.post@n3.nabble.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin pgsql-performance

Did you try
- runing multiple inserts in parallel,
- Stop wal archiving,
- Tune fetch sise ?

Regards
PAscal

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

In response to

Fwd: increase insert into local table from remote oracle table preformance at 2018-08-13 20:35:05 from Mariel Cherkassky

Responses

Re: Fwd: increase insert into local table from remote oracle table preformance at 2018-08-14 11:33:37 from Mariel Cherkassky

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Ilyass Kaouam	2018-08-13 21:10:03	Re: Secure dump file
Previous Message	Bear Giles	2018-08-13 20:57:05	Re: Setting up SSL for postgre

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Mark Kirkwood	2018-08-14 05:21:23	Re: increase insert into local table from remote oracle table preformance
Previous Message	Mariel Cherkassky	2018-08-13 20:35:05	Fwd: increase insert into local table from remote oracle table preformance