I’m trying to decide if either MySQL or PostgreSQL would be more suitable for an application that will get hit by potentially thousands of simultaneous requests at a time.
During research, one fact that stands out is that PostgreSQL forks a new process for each connection, whereas MySQL creates a new thread to handle each connection.
Does this mean that MySQL is more efficient than PostgreSQL at handling many concurrent connections?
How much of an impact does this difference have on how well both systems scale? Is it something that I should worry about to begin with?