Stephen Frost
Chief Technology Officer at Crunchy Data Solutions, Inc.
Stephen Frost is the Chief Technology Officer for Crunchy Data Solutions, Inc.
Stephen is a PostgreSQL Committer and Major Contributor, his previous work has included implementing the role system in 8.1 (replacing the previous user/group system), column-level privileges in 8.4 and improvements to PL/pgSQL.
Upcoming presentations
No upcoming presentations...
Past presentations
Developer Unconference
Developer Unconference
This is a developer unconference.
Hosted by Bruce Momjian
Do come if you have interesting Postgres feature ideas
Nov 17 2020
We'll be looking at PostgreSQL configuration options (postgresql.conf) for logging and basic tuning parameters, going over EXPLAIN and EXPLAIN ANALYZE output for select queries (and the auto_explain module), what the EXPLAIN output means in terms of how the query is being executed, and then going over ways to improve the queries, including index creation, rewriting the query to allow PG to use ...
PostgreSQL has long had a complex and interesting set of permissions available through the GRANT system. There is another system which exists in many other RDBMS's known as row-level security (RLS), where the rows returned is filtered based on a policy implemented on the table. In this talk we'll review RLS, provide examples and use-cases, discuss the work which has been done on adding Row Leve...
Review of the PostgreSQL Authorization system, including roles and the GRANT/REVOKE system. We'll also cover various per-role options including the superuser flag and what a superuser can do that normal users can't (and why superuser is particularly dangerous...).