i tried to host the postgres 16 db in a windows 19 server that is in the same region of the backend server that is also a windows server , it only saves 10 rows per second even when having pool of open sessions with db ,
but on localhost it saves 100k in less than a sec , I don’t believe that two servers in same region will have this slow connection , because when sending via HTTP , I can receive them requests , but connecting backend to db directly is not able to surpass 10 insertions/sec .
note that I’m only trying to insert new rows , I’m not trying to execute complex queries .