
PG Edge Cache, Postgres & OpenAI, citext to Collations, Compression Options | Scaling Postgres 254
Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss PG Edge Cache, using Postgres & OpenAI, migrating citext to case-insenstive collations and PG16 compression options.
Content Discussed
- PostgreSQL Edge Cache (PGEC)
- Cache consistency with logical streaming replication
- Consistent caching with PostgreSQL logical replication and a Redis API
- What's Postgres Got To Do With AI?
- How to migrate from Django’s PostgreSQL CI Fields to use a case-insensitive collation
- More compression options for pg_dump in PostgreSQL 16
- Unlogged tables in Postgres: Is their data truly gone after a crash?
- PostgreSQL Basics: Object Ownership and Default Privileges
- Store Trees As Materialized Paths
- PostgreSQL: Speeding up recursive queries and hierarchic data
- PostgreSQL: ltree vs. WITH RECURSIVE
- Announcing PgManage 1.0a
- PostgreSQL Patch of Interest (to me): Transaction Timeout
- ER diagrams with SQL and Mermaid
- [YouTube] Postgres Architecture Explained
- [YouTube] Postgres System Columns Explained (ctid, xmin,xmax)
- Postgres Raster Query Basics
- JSON
- Frits Hoogland
- Ruby IDE Showdown With Adrian Marin, CJ Avilla & Eric Berry | Rubber Duck Dev Show 75