Hi, we probably need more inforation to offer anything useful here, e.g:
- The network bandwidth between the 2 hosts
- the number of partitions on the Postgres end (i.e how many days in
your case)
- single or batched INSERT
The lack of indexes is probably not going to effect INSERT performance
that much, but the number of partition tables has a huge impact, so we
need to know this stuff!
Cheers
Mark
On 14/08/18 08:34, Mariel Cherkassky wrote:
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.
