In this episode of Scaling Postgres, we review articles covering declarative partitioning, handling permissions to view data, and the speed of triggers.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
- https://docs.google.com/presentation/d/136DZZJeVYklEmjl3QoX_-C6NPyMlqmUDuljpO8G8bys
- https://newbiedba.wordpress.com/2018/07/02/postgresql-10-how-to-create-a-partitioned-table-based-on-jsonb-column-field-value/
- https://blog.2ndquadrant.com/scaling-iot-time-series-data-postgres-bdr/
- https://www.citusdata.com/blog/2018/07/03/masking-columns-in-postgresql/
- https://www.cybertec-postgresql.com/en/rules-or-triggers-to-log-bulk-updates/
- https://blog.jooq.org/2018/07/05/postgresql-11s-support-for-sql-standard-groups-and-exclude-window-function-clauses/
- https://rjuju.github.io/postgresql/2018/07/03/diagnostic-of-unexpected-slowdown.html
- https://tapoueh.org/blog/2018/07/postgresql-concurrency-isolation-and-locking/