To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/162-custom-data-types-row-level-triggers-dynamic-plpgsql-columns-citext-usage/
In this episode of Scaling Postgres, we discuss implementing row level triggers, how to return dynamic columns using pl/pgsql, and when to use citext.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/courses/postgresql-performance-starter-kit/
Timestamps:
00:00 - Intro
00:28 - Creating Custom Postgres Data Types in Rails
03:21 - What to return from a PostgreSQL row level trigger?
05:50 - Getting value from dynamic column in pl/PgSQL triggers?
07:49 - Handling case insensitive strings - EXPLAINING POSTGRESQL
08:38 - Hash Index Internals
09:13 - Calling Stored Procedure from JAVA – Part 2
09:30 - Visibility with query cache
10:10 - Pavlo Golub
10:22 - Outro
#postgres #postgresql
