public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rick Otten <[email protected]>
To: Daniel Blanch Bataller <[email protected]>
Cc: Mariel Cherkassky <[email protected]>
Cc: pgsql-performa. <[email protected]>
Subject: Re: performance problem on big tables
Date: Mon, 14 Aug 2017 11:45:01 -0400
Message-ID: <CAMAYy4+C+FtGOJTB6OtK2cisJtkoZSMMrEKdxRQS13oWBgtpGA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CA+t6e1m06=RkReCDxdyjwAMwVwuKxakV8TKmQ2cnMLFYbOjMCA@mail.gmail.com>
	<[email protected]>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

Moving that many gigs of data across your network could also take a long
time simply depending on your network configuration.  Before spending a
huge amount of energy tuning postgresql, I'd probably look at how long it
takes to simply copy 20 or 30 G of data between the two machines.



> El 14 ago 2017, a las 15:24, Mariel Cherkassky <
> [email protected]> escribió:
>
> I have performance issues with two big tables. Those tables are located on
> an oracle remote database. I'm running the quert : insert into
> local_postgresql_table select * from oracle_remote_table.
>
> The first table has 45M records and its size is 23G. The import of the
> data from the oracle remote database is taking 1 hour and 38 minutes. After
> that I create 13 regular indexes on the table and it takes 10 minutes per
> table ->2 hours and 10 minutes in total.
>
> The second table has 29M records and its size is 26G. The import of the
> data from the oracle remote database is taking 2 hours and 30 minutes. The
> creation of the indexes takes 1 hours and 30 minutes (some are indexes on
> one column and the creation takes 5 min and some are indexes on multiples
> column and it takes 11 min.
>
>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: performance problem on big tables
  In-Reply-To: <CAMAYy4+C+FtGOJTB6OtK2cisJtkoZSMMrEKdxRQS13oWBgtpGA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox