I’m using Prisma to seed my database using fly proxy. It’s only about 5 tables and 200 entries total. Inserting rows with only scalar data is fast, but I have a few tables with JSON fields (data is less than 2kb for each) that each take minutes to insert when the whole script takes about a second to run with a local postgres instance.
The postgres instance and my docker container are both in the same region which is close to my physical location. As far as I can tell, I’m mostly using configuration defaults everywhere. I tried using a VPN to see if it is a network issue, but it did not help. What other options could I explore to improve the performance of inserting rows with JSON fields?