MIME-Version: 1.0
In-Reply-To: 
 <CA+t6e1nG8bF4-hrvjijhJ_nC5OXmw32eXNYdxuYMkPSk2QLrag@mail.gmail.com>
References: 
 <CA+t6e1m06=RkReCDxdyjwAMwVwuKxakV8TKmQ2cnMLFYbOjMCA@mail.gmail.com>
 <CA+t6e1nG8bF4-hrvjijhJ_nC5OXmw32eXNYdxuYMkPSk2QLrag@mail.gmail.com>
From: Jeff Janes <jeff.janes@gmail.com>
Date: Tue, 15 Aug 2017 09:13:30 -0700
Message-ID: 
 <CAMkU=1zh2iGYVriwcMOXS8GB7BKB-k6Am1xK6H1LUh_-RwLjqQ@mail.gmail.com>
Subject: Re: performance problem on big tables
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Type: multipart/alternative; boundary="f4030435bd407718a70556cd0fd1"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--f4030435bd407718a70556cd0fd1
Content-Type: text/plain; charset="UTF-8"

On Tue, Aug 15, 2017 at 3:06 AM, Mariel Cherkassky <
mariel.cherkassky@gmail.com> wrote:

> Hi,
> So I I run the cheks that jeff mentioned :
> \copy (select * from oracle_remote_table) to /tmp/tmp with binary - 1 hour
> and 35 minutes
> \copy local_postresql_table from /tmp/tmp with binary - Didnt run because
> the remote oracle database is currently under maintenance work.
>

The "\copy...from" doesn't depend on oracle, it would be only depend on
local file system (/tmp/tmp), provided that the "\copy...to" finished.
Anyway, given the length of time it took, I think you can conclude the
bottleneck is in oracle_fdw itself, or in Oracle, or the network.

Cheers,

Jeff

--f4030435bd407718a70556cd0fd1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote">On T=
ue, Aug 15, 2017 at 3:06 AM, Mariel Cherkassky <span dir=3D"ltr">&lt;<a hre=
f=3D"mailto:mariel.cherkassky@gmail.com" target=3D"_blank">mariel.cherkassk=
y@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div di=
r=3D"rtl"><div dir=3D"ltr">Hi,</div><div dir=3D"ltr">So I I run the cheks t=
hat jeff mentioned : =C2=A0</div><div dir=3D"ltr"><div style=3D"font-size:1=
2.8px">\copy (select * from oracle_remote_table) to /tmp/tmp with binary - =
1 hour and 35 minutes</div><div style=3D"font-size:12.8px">\copy local_post=
resql_table from /tmp/tmp with binary - Didnt run because the remote oracle=
 database is currently under maintenance work.</div></div></div></blockquot=
e><div><br></div><div>The &quot;\copy...from&quot; doesn&#39;t depend on or=
acle, it would be only depend on local file system (/tmp/tmp), provided tha=
t the &quot;\copy...to&quot; finished.=C2=A0 Anyway, given the length of ti=
me it took, I think you can conclude the bottleneck is in oracle_fdw itself=
, or in Oracle, or the network.</div><div><br></div><div>Cheers,</div><div>=
<br></div><div>Jeff</div></div></div></div>

--f4030435bd407718a70556cd0fd1--