It's probably easy to do if you know it's an issue to begin with. I've run into ...

AgentME on July 12, 2019 | parent | context | favorite | on: Twitter was down

It's probably easy to do if you know it's an issue to begin with. I've run into this scenario before (running sql queries to read data that turned out to lock everything) and it caught me by surprise. Why would a read query cause the database to lock anything? I thought databases did stuff like multiversion concurrency control to make locks like that unnecessary.

joevandyk on July 12, 2019 [–]

Doing large queries on a Postgres standby had the potential to mess up the master, depending on configuration settings.