View Access Logging - Fix it in PostgreSQL
How to fix the view access logging in an established database. Find out how Kirk Wolak renamed and tracked all the views in his Postgres DB.
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-682d8c5235fab327791361/] […]
