Postgres FM

159 Episodes

1. EXPLAIN

   Published: 05/01/2024
2. work_mem

   Published: 31/12/2023
3. Partitioning by ULID

   Published: 22/12/2023
4. Hash indexes

   Published: 15/12/2023
5. Constraints

   Published: 08/12/2023
6. Events

   Published: 01/12/2023
7. Subtransactions

   Published: 24/11/2023
8. Companion databases

   Published: 17/11/2023
9. Blue-green deployments

   Published: 10/11/2023
10. Data model trade-offs

    Published: 03/11/2023
11. Under-indexing

    Published: 27/10/2023
12. Over-indexing

    Published: 20/10/2023
13. Query hints

    Published: 13/10/2023
14. Stop and start Postgres faster

    Published: 07/10/2023
15. Backups

    Published: 29/09/2023
16. Postgres 16

    Published: 22/09/2023
17. Logical replication

    Published: 15/09/2023
18. Our favourite v16 feature

    Published: 08/09/2023
19. Connections

    Published: 01/09/2023
20. Decoupled storage and compute

    Published: 25/08/2023