The four horsemen behind thousands of Postgres outages is a self-promotion article, but it can teach you some things about Postgres, so I allow it.

A few corrections, though. Postgres does have a pg_hint_plan extension that allows you to modify the plan yourself. However, if you need to use that, there may be something odd with your queries in the first place.

The second thing is JSON. Postgres works with it and a lot of people use JSON fields, but this database was not created for JSON in the first place. So, if you need to work mostly with JSON, you would probably be better with another storage, or you could deserialize JSON fields into columns and work with data as usual.

#databases