Scaling Postgres podkast

Scaling Postgres

Creston Jamison

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.

100 odcinki(-ów)

  • Scaling Postgres podkast

    Episode 193 Entity-Attribute-Value Design | JSON Subscripting | mysql-fdw Push-down | New Regex

    9:27

    In this episode of Scaling Postgres, we discuss using entity-attribute-value designs, new JSON subscripting capabilities, the mysql-fdw support for aggregate pushdowns and new regex functions in PG 15. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/entity-attribute-value-eav-design-in-postgresql-dont-do-it/ https://blog.logrocket.com/whats-new-json-postgresql-v14/ https://www.enterprisedb.com/blog/aggregate-push-down-mysqlfdw https://www.depesz.com/2021/11/26/waiting-for-postgresql-15-add-assorted-new-regexp_xxx-sql-functions/ https://blog.crunchydata.com/blog/using-timescaledb-extension-with-the-pgo-the-postgres-operator https://www.highgo.ca/2021/11/27/how-to-run-a-specific-regression-test/ https://postgresql.life/post/pavel_luzanov/
  • Scaling Postgres podkast

    Episode 192 Foreign Key Indexes | Graph Queries | Linux Huge Pages | Text Column Size

    12:40

    In this episode of Scaling Postgres, we discuss if foreign keys should have indexes, how to run graph queries, how to configure Linux huge pages and the benefits as well as text size similarities. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.percona.com/blog/should-i-create-an-index-on-foreign-keys-in-postgresql/ https://www.youtube.com/watch?v=_RXfnnqsLlw https://www.enterprisedb.com/blog/improving-postgresql-performance-without-making-changes-postgresql https://www.depesz.com/2021/11/19/does-varcharn-use-less-disk-space-than-varchar-or-text/ https://pganalyze.com/blog/postgresql-views-django-python https://www.enterprisedb.com/blog/pg-phriday-isolating-postgres-repmgr https://www.cybertec-postgresql.com/en/postgresql-on-wsl2-for-windows-install-and-setup/ https://www.depesz.com/2021/11/16/waiting-for-postgresql-15-allow-publishing-the-tables-of-schema/ https://www.migops.com/blog/2021/11/15/postgresql-15-will-include-some-more-regexp-functions/ https://stackgres.io/blog/easily-running-babelfish-for-postgresql-on-kubernetes/ https://postgresql.life/post/louise_grandjonc/ https://www.rubberduckdevshow.com/episodes/21-what-is-devops/
  • Scaling Postgres podkast

    Nie przegap odcinka z kanału Scaling Postgres! Subskrybuj bezpłatnie w aplikacji GetPodcast.

    iOS buttonAndroid button
  • Scaling Postgres podkast

    Episode 191 Man-In-The-Middle | pg_auto_failover | Lesser Known Features | LZ4 Compression

    14:55

    In this episode of Scaling Postgres, we discuss new releases of Postgres due to a man-in-the-middle vulnerability, the high availability solution pg_auto_failover, lesser known Postgres features and LZ4 compression. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/postgresql-141-135-129-1114-1019-and-9624-released-2349/ https://www.enterprisedb.com/blog/postgres-mitm21-vulnerabilities https://www.youtube.com/watch?v=fuYwlVw0e_o https://www.pgbouncer.org/2021/11/pgbouncer-1-16-1 https://tapoueh.org/blog/2021/11/an-introduction-to-the-pg_auto_failover-project/ https://hakibenita.com/postgresql-unknown-features https://www.postgresql.fastware.com/blog/what-is-the-new-lz4-toast-compression-in-postgresql-14 https://blog.jooq.org/postgresql-14s-enable_memoize-for-improved-performance-of-nested-loop-joins/ https://blog.timescale.com/blog/generating-more-realistic-sample-time-series-data-with-postgresql-generate_series/ https://blog.crunchydata.com/blog/multifactor-sso-authentication-for-postgres-on-kubernetes https://dev.to/yugabyte/postgres-pgagroal-connectionpool-23fc https://blog.rustprooflabs.com/2021/11/postgis-find-openstreetmap-missing-crossing https://postgresql.life/post/john_naylor/ https://www.rubberduckdevshow.com/episodes/20-how-do-you-start-testing/
  • Scaling Postgres podkast

    Episode 190 Hello Babelfish | Planner Deconstruction | Exist & Not Exist | Fun With SQL

    12:33

    In this episode of Scaling Postgres, we discuss the open sourcing of Babelfish, deconstructing the Postgres planner, when to avoid exist & not exist and having fun with SQL. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://babelfishpg.org/blog/releases/2021/10/babelfish-launch/ https://aws.amazon.com/blogs/aws/goodbye-microsoft-sql-server-hello-babelfish/ https://pganalyze.com/blog/deconstructing-the-postgres-planner https://postgres.ai/blog/20211103-three-cases-against-if-not-exists-and-if-exists-in-postgresql-ddl https://blog.crunchydata.com/blog/fun-with-sql-in-postgres-finding-revenue-accrued-per-day https://notes.eatonphil.com/exploring-plpgsql-forth-like.html https://www.highgo.ca/2021/11/01/the-postgresql-timeline-concept/ https://blog.crunchydata.com/blog/patroni-etcd-in-high-availability-environments https://blog.crunchydata.com/blog/resize-postgres-kubernetes-volume-instance-sets https://aws.amazon.com/blogs/database/vehicle-routing-optimization-with-amazon-aurora-postgresql-compatible-edition/ https://postgresql.life/post/tatsuro_yamada/ https://www.rubberduckdevshow.com/episodes/19-how-much-time-should-you-spend-planning/
  • Scaling Postgres podkast

    Episode 189 Index Downsides | TCP Keep Alive | Development with Postgres | Learning PL/pgSQL

    15:27

    In this episode of Scaling Postgres, we discuss the downsides of indexes, TCP keep alive options, developing with Postgres as your DB and learning PL/pgSQL. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://postgres.ai/blog/20211029-how-partial-and-covering-indexes-affect-update-performance-in-postgresql https://www.cybertec-postgresql.com/en/tcp-keepalive-for-a-better-postgresql-experience/ https://www.youtube.com/watch?v=mliO5_XhAKE https://notes.eatonphil.com/exploring-plpgsql.html https://blog.crunchydata.com/blog/secure-postgresql-14-with-the-cis-benchmark https://blog.crunchydata.com/blog/database-security-best-practices-on-kubernetes https://blog.crunchydata.com/blog/encrypting-postgres-data-at-rest-in-kubernetes https://postgresql.life/post/alexander_kukushkin/ https://www.rubberduckdevshow.com/episodes/18-how-many-3rd-party-libraries-should-you-use/
  • Scaling Postgres podkast

    Episode 188 Automatic Indexing | Function Pipelines | With Hold Cursors | Query Scans

    15:27

    In this episode of Scaling Postgres, we discuss automatic indexing, function pipelines, with hold cursors and the different query scans. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.depesz.com/2021/10/22/why-is-it-hard-to-automatically-suggest-what-index-to-create/ https://blog.timescale.com/blog/function-pipelines-building-functional-programming-into-postgresql-using-custom-operators/ https://www.cybertec-postgresql.com/en/with-hold-cursors-and-transactions-in-postgresql/ https://arctype.com/blog/postgres-explain-analyze-scan/ https://postgres.ai/blog/20211018-postgresql-lock-trees https://blog.crunchydata.com/blog/postgres-queries-for-projecting-monthly-revenue-run-rate https://about.sourcegraph.com/blog/postgres-text-search-balancing-query-time-and-relevancy/ https://elephanttamer.net/?p=68 https://aws.amazon.com/blogs/database/upgrade-amazon-rds-and-amazon-aurora-postgresql-version-9-6/ https://postgresql.life/post/ivan_panchenko/ https://www.rubberduckdevshow.com/episodes/17-practicing-continuous-integration-deployment/
  • Scaling Postgres podkast

    Episode 187 Sharding | Federation | Linux HugePages | Performance Tuning

    15:06

    In this episode of Scaling Postgres, we discuss one method to shard a database, federating your database, the benefits of configuring linux HugePages and performance tuning. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.notion.so/blog/sharding-postgres-at-notion https://blog.crunchydata.com/blog/multi-cluster-postgres-federation-on-kubernetes-with-postgres-14-using-gitops https://www.percona.com/blog/why-linux-hugepages-are-super-important-for-database-servers-a-case-with-postgresql/ https://www.enterprisedb.com/blog/webinar-recap-tuning-tips-maximize-postgres-performance https://aws.amazon.com/blogs/database/tune-sorting-operations-in-postgresql-with-work_mem/ https://www.cybertec-postgresql.com/en/show-tables-in-postgresql-whats-wrong-with-it/ https://blog.rustprooflabs.com/2021/10/postgres-14-query-id https://www.highgo.ca/2021/10/15/backup-label-in-postgresql/ https://www.postgresonline.com/journal/index.php?/archives/401-Multirange-types-in-PostgreSQL-14.html https://fluca1978.github.io/2021/10/09/PostgreSQLOnOpenBSD.html https://postgresql.life/post/sebastiaan_mannem/  
  • Scaling Postgres podkast

    Episode 186 Select For Update | PGx Framework | Cool Additions | Full-Text Search

    8:41

    In this episode of Scaling Postgres, we discuss select for update, the pgx framework to generate extensions, cool additions to Postgres 14 and full-text search. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.migops.com/blog/2021/10/05/select-for-update-and-its-behavior-with-foreign-keys-in-postgresql/ https://blog.rustprooflabs.com/2021/10/pgdd-extension-using-pgx-rust https://www.enterprisedb.com/blog/cool-new-contributions-postgresql-14 https://arctype.com/blog/postgres-full-text-search/ https://www.enterprisedb.com/postgresql-database-backup-recovery-what-works-wal-pitr https://yugonagata-pgsql.blogspot.com/2021/10/transition-tables-in-imcremental-view.html https://www.enterprisedb.com/blog/how-set-kerberos-authentication-using-active-directory-postgresql-database https://www.cybertec-postgresql.com/en/openstreetmap-service-by-cybertec/ https://blog.crunchydata.com/blog/postgresql-14-on-kubernetes https://postgresql.life/post/amit_kapila/ https://www.rubberduckdevshow.com/episodes/16-when-should-you-comment-your-code/
  • Scaling Postgres podkast

    Episode 185 Postgres 14 Released | Using JSON | Not Using Indexes | Sequence Gaps

    21:20

    In this episode of Scaling Postgres, we discuss the release of Postgres 14, how best to use JSON, why are your indexes not being used and sequence gaps. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/postgresql-14-released-2318/ https://www.citusdata.com/blog/2021/10/01/how-we-shipped-postgres-14-on-azure-within-a-day/ https://www.instaclustr.com/postgresql-14/ https://www.migops.com/blog/2021/09/29/upgrading-postgresql-9-6-to-postgresql-13/ https://www.cybertec-postgresql.com/en/json-postgresql-how-to-use-it-right/ https://www.depesz.com/2021/09/27/using-recursive-queries-to-get-distinct-elements-from-table/ https://www.pgmustard.com/blog/why-isnt-postgres-using-my-index https://postgres.ai/blog/20210923-zero-downtime-postgres-schema-migrations-lock-timeout-and-retries https://www.cybertec-postgresql.com/en/gaps-in-sequences-postgresql/ https://mydbanotebook.org/post/auto-increment/ https://blog.crunchydata.com/blog/dynamic-ddl-in-postgresql https://www.highgo.ca/2021/10/01/postgresql-14-continuous-archiving-and-point-in-time-recovery/ https://blog.timescale.com/blog/how-to-evaluate-your-data-directly-within-the-database-and-make-your-analysis-more-efficient/ https://www.ongres.com/blog/boost-query-performance-using-fdw-with-minimal-changes/ https://postgresql.life/post/jeff_davis/ https://www.rubberduckdevshow.com/episodes/15-when-to-use-uuids/
  • Scaling Postgres podkast

    Episode 184 Postgres 14 RC1 | Little Things | Index Advisor | Million Inserts

    12:38

    In this episode of Scaling Postgres, we discuss Postgres 14 RC1, little improvements in PG14, an index advisor and how to handle 1 million insert statements. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/postgresql-14-rc-1-released-2309/ https://blog.crunchydata.com/blog/postgres-14-its-the-little-things https://pganalyze.com/blog/introducing-pganalyze-index-advisor https://dev.to/yugabyte/when-you-have-millions-of-insert-statements-in-a-file-3nck https://fluca1978.github.io/2021/09/23/OracleAlterSequence.html https://www.cybertec-postgresql.com/en/building-an-oracle-to-postgresql-migrator-lessons-learned/ https://b-peng.blogspot.com/2021/09/reserved-connections.html https://b-peng.blogspot.com/2021/09/enable-shared-relcache.html https://postgresql.life/post/michael_goldberg/ https://www.rubberduckdevshow.com/episodes/14-background-job-processing/

Odkrywaj najlepsze podcasty dzięki bezpłatnej aplikacji GetPodcast.

Subskrybuj ulubione podcasty, słuchaj odcinków offline i sprawdzaj najlepsze polecane podcasty.

iOS buttonAndroid button