View Access Logging - Fix it in PostgreSQL
By Kirk Wolak Continuous Improvement is an important part of reducing technical debt. Over 30 years our active database has […]
UNION ALL, data types and performance
by
Laurenz Albe |
12.2022 A while ago, I wrote about the performance impact of query parameter data types. Recently I encountered a similar […]
View permissions and row-level security in PostgreSQL
by
Laurenz Albe |
06.2022 The details of how view permissions are checked have long puzzled me. PostgreSQL v15 introduces “security invoker” views, which […]
Tracking view dependencies in PostgreSQL
by
Laurenz Albe |
09.2019 We all know that in PostgreSQL we cannot drop an object if there are view dependencies on it: [crayon-67e330d728963497211986/] […]
