In this episode of Scaling Postgres, we discuss how data can flow from your OLTP to parquet files for analytics, parallel queries, view inlining and partitioning advice.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/353-oltp-to-parquet-for-analytics/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss how you can always optimize more, avoiding deadlocks, casting & indexes and pg_hint_plan best practices.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/352-you-can-always-optimize-more/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we talk about some features you may want to avoid like commit_delay, index_cleanup off, & logon triggers, a way to detect a table rewrite and a zero downtime upgrade.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/351-features-to-avoid/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints and better group by statistics.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/350-seven-years-of-scaling-postgres/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss the dangers of temporary tables, better transparent data encryption, pig the extension wizard, and table level lock considerations.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/349-the-dangers-of-temporary-tables/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss whether the future of containers and Postgres, UUIDv7 commit, and a pg_duckdb interview.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/348-the-future-is-containers/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss the new pg_incremental extension for processing data pipelines, a set of Postgres monitoring queries, handling alter table retries and large object dump performance.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/347-easy-incremental-data-processing/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss things I do not do such as use default partitions, play column Tetris, ELT using special data types or create 7+ millions tables in a database.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/346-things-i-do-not-do-in-postgres/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss OrioleDB getting Postgres over 5 times faster, historical OLAP performance, efficient queries and whether you should us track_planning.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/345-over-5x-faster-postgres/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss new releases, collation speed, ZFS performance, insert benchmarking and pglz vs. lz4 performance.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/344-performance-hard-things/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/