PostgreSQL Antipatterns: harmful JOINs and OR
Beware of operations that bring buffers… We will look at some universal approaches to optimizing queries in PostgreSQL through a simple example. Whether to use them or not is up to you, but it's worth knowing about them. In some subsequent PG versions, the situation may change with a "smarter" planner, but for versions 9.4/9.6, it looks pretty much the same, as shown in these examples. Let’s take a quite realistic query: SELECT […]
