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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Fwd: increase insert into local table from remote oracle table preformance
From: legrand legrand <legrand_legrand@xxxxxxxxxxx>
Date: Mon, 13 Aug 2018 14:03:58 -0700 (MST)
In-reply-to: <CA+t6e1m7HJ=2p6kK=M2JrJpUQek3zW6gGt5cOT9-qdDvqa_Qpw@mail.gmail.com>
References: <CA+t6e1m7HJ=2p6kK=M2JrJpUQek3zW6gGt5cOT9-qdDvqa_Qpw@mail.gmail.com>

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

Follow-Ups:
- Re: Fwd: increase insert into local table from remote oracle table preformance
  - From: Mariel Cherkassky

References:
- Fwd: increase insert into local table from remote oracle table preformance
  - From: Mariel Cherkassky

Prev by Date: Fwd: increase insert into local table from remote oracle table preformance
Next by Date: Re: Fwd: increase insert into local table from remote oracle table preformance
Previous by thread: Fwd: increase insert into local table from remote oracle table preformance
Next by thread: Re: Fwd: increase insert into local table from remote oracle table preformance
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux