| From: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL mailing lists <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Fwd: increase insert into local table from remote oracle table preformance |
| Date: | 2018-08-13 20:35:05 |
| Message-ID: | CA+t6e1m7HJ=2p6kK=M2JrJpUQek3zW6gGt5cOT9-qdDvqa_Qpw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | 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 | Bear Giles | 2018-08-13 20:57:05 | Re: Setting up SSL for postgre |
| Previous Message | Mariel Cherkassky | 2018-08-13 20:34:46 | increase insert into local table from remote oracle table preformance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | legrand legrand | 2018-08-13 21:03:58 | Re: Fwd: increase insert into local table from remote oracle table preformance |
| Previous Message | Mariel Cherkassky | 2018-08-13 20:34:46 | increase insert into local table from remote oracle table preformance |