I started using PostgreSQL because, at the time, MySQL wouldn't do subqueries. The fact it silently truncated VARCHAR data to the size of the column and didn't give out an error didn't help much.
Overall, my impression is that the project's philosophy is to do the Correct Thing, even if it's slow.