PostgreSQL COPY command is much slower locally compared to remote server with identical specs
I’m encountering a performance issue with the PostgreSQL COPY
command when running it locally. My remote backend app server and my local PC have identical specs (both with SSDs, similar RAM, and CPU cores). The PostgreSQL database itself is hosted on a different remote server, and the database can only be accessed through a specific whitelisted internet connection.