'Importing Large Table from SQL to Postgres RDS AWS
I am looking for advice on how to increase the speed of an export of a
SQL Server table with around 20 million records into a Postgres RDS. Both are on an AWS Server as separate RDS instances. I am doing this operation currently through SQL's Export Wizard. This is taking an extremely long time, only appending about 200 words per second I am not very experienced with Postgres but I understand increasing max_wal_size may help with speeds. How would I go about changing this parameter?
I am just looking for suggestions on how to optimize the speed of the export or if there is another more efficient way to do this, I would appreciate learning about that.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|