How Can PostgreSQL Hurt When You Don't Expect It To?

I will share my experience of investigating performance problems in PostgreSQL using several vivid incidents as examples.