MIME-Version: 1.0
In-Reply-To: 
 <CAMkU=1zh2iGYVriwcMOXS8GB7BKB-k6Am1xK6H1LUh_-RwLjqQ@mail.gmail.com>
References: 
 <CA+t6e1m06=RkReCDxdyjwAMwVwuKxakV8TKmQ2cnMLFYbOjMCA@mail.gmail.com>
 <CA+t6e1nG8bF4-hrvjijhJ_nC5OXmw32eXNYdxuYMkPSk2QLrag@mail.gmail.com>
 <CAMkU=1zh2iGYVriwcMOXS8GB7BKB-k6Am1xK6H1LUh_-RwLjqQ@mail.gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Tue, 15 Aug 2017 19:44:51 +0200
Message-ID: 
 <CAFj8pRA1uNq96KYVR+NP_M3GfqqvuBOh-DmMuZAcYqCdtJ_LiQ@mail.gmail.com>
Subject: Re: performance problem on big tables
To: Jeff Janes <jeff.janes@gmail.com>
Cc: Mariel Cherkassky <mariel.cherkassky@gmail.com>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Type: multipart/alternative; boundary="001a113d6ddc804e960556ce58b4"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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

2017-08-15 18:13 GMT+02:00 Jeff Janes <jeff.janes@gmail.com>:

> 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.
>

dumping from Oracle is not fast - I seen it when oracle_fdw or ora2pg cases.

Regards

Pavel


>
> Cheers,
>
> Jeff
>

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

<div dir=3D"ltr"><br><div class=3D"gmail_extra"><br><div class=3D"gmail_quo=
te">2017-08-15 18:13 GMT+02:00 Jeff Janes <span dir=3D"ltr">&lt;<a href=3D"=
mailto:jeff.janes@gmail.com" target=3D"_blank">jeff.janes@gmail.com</a>&gt;=
</span>:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bo=
rder-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div class=3D"g=
mail_extra"><div class=3D"gmail_quote">On Tue, Aug 15, 2017 at 3:06 AM, Mar=
iel Cherkassky <span dir=3D"ltr">&lt;<a href=3D"mailto:mariel.cherkassky@gm=
ail.com" target=3D"_blank">mariel.cherkassky@gmail.com</a>&gt;</span> wrote=
:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-le=
ft:1px #ccc solid;padding-left:1ex"><div dir=3D"rtl"><div dir=3D"ltr">Hi,</=
div><div dir=3D"ltr">So I I run the cheks that jeff mentioned : =C2=A0</div=
><div dir=3D"ltr"><div style=3D"font-size:12.8px">\copy (select * from orac=
le_remote_table) to /tmp/tmp with binary - 1 hour and 35 minutes</div><div =
style=3D"font-size:12.8px">\copy local_postresql_table from /tmp/tmp with b=
inary - Didnt run because the remote oracle database is currently under mai=
ntenance work.</div></div></div></blockquote><div><br></div><div>The &quot;=
\copy...from&quot; doesn&#39;t depend on oracle, it would be only depend on=
 local file system (/tmp/tmp), provided that the &quot;\copy...to&quot; fin=
ished.=C2=A0 Anyway, given the length of time it took, I think you can conc=
lude the bottleneck is in oracle_fdw itself, or in Oracle, or the network.<=
/div></div></div></div></blockquote><div><br></div><div>dumping from Oracle=
 is not fast - I seen it when oracle_fdw or ora2pg cases.</div><div><br></d=
iv><div>Regards</div><div><br></div><div>Pavel</div><div><br></div><div>=C2=
=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;borde=
r-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmai=
l_extra"><div class=3D"gmail_quote"><div><br></div><div>Cheers,</div><div><=
br></div><div>Jeff</div></div></div></div>
</blockquote></div><br></div></div>

--001a113d6ddc804e960556ce58b4--