Scaling Postgres Episode 243 IN vs ANY, Ghost Conditions, Percentage Calculations, Variadic Unnest

In this episode of Scaling Postgres, we discuss IN vs. ANY performance, ghost conditions, percentage calculations using window functions and using variadic unnest.

Content Discussed

• 5mins of Postgres E45: IN lists vs ANY operator: Bind parameters and performance
• Ghost Conditions For Unindexed Columns
• Percentage Calculations Using Postgres Window Functions
• Variadic Unnest
• SQL or NoSQL? Why not use both (with PostgreSQL)?
• PostgreSQL ERROR: permission denied for schema public
• Global Index, benchmark with pgbench
• PostgreSQL scary settings: data_sync_retry
• Materialized views
• Tobias Bussmann

YouTube Video