| From: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | increase insert into local table from remote oracle table preformance |
| Date: | 2018-08-13 20:34:46 |
| Message-ID: | CA+t6e1nxh1VVMjD2NJZV_Mcb7UyF8-F3y=hxjamuMFA1bAk2Jg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Hi,
I'm using postgresql v10.4. I have a local partitioned table (by range -
data, every day has its own table). I'm using the oracle_fdw extension to
bring data from the oracle partitioned table into my local postgresql
(insert into local select * from remote_oracle). Currently, I dont have any
indexes on the postgresql`s table. It takes me 10 hours to copy 200G over
the network and it is very slow.
Any recommandations what can I change or improve ?
Thanks , Mariel.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mariel Cherkassky | 2018-08-13 20:35:05 | Fwd: increase insert into local table from remote oracle table preformance |
| Previous Message | Mark Williams | 2018-08-13 19:57:10 | RE: Setting up SSL for postgre |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mariel Cherkassky | 2018-08-13 20:35:05 | Fwd: increase insert into local table from remote oracle table preformance |
| Previous Message | Jeff Janes | 2018-08-01 15:21:21 | Re: Performance difference in accessing differrent columns in a Postgres Table |