Are postgres connection able to manage multiple requests at the same time?
No, you can only have a single statement executing at the same time on a PostgreSQL connections.
PostgreSQL v14 introduces pipelining of SQL statements, but that still means that one statement will execute after the other. Besides, I doubt that Npgsql already has support for that.
Use several database connections.