×
PG Tips public
[search 0]
×
Best PG Tips podcasts we could find (updated February 2020)
Best PG Tips podcasts we could find
Updated February 2020
Join millions of Player FM users today to get news and insights whenever you like, even when you're offline. Podcast smarter with the free podcast app that refuses to compromise. Let's play!
Join the world's best podcast app to manage your favorite shows online and play them offline on our Android and iOS apps. It's free and easy!
More
show episodes
 
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.
 
Loading …
show series
 
In this episode of Scaling Postgres, we discuss the use cases for UUIDs, using pg_settings, setting up an automated restore and the future of parallelism. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.depesz.com/2020/02/19/why-im-not-fan-of-uuid-datatype/ https://medium.com/yugabyt…
 
In this episode of Scaling Postgres, we discuss new postgres releases, useless vacuuming, isolation differences between databases, and different ways to compress WAL files. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/2011/ https://www.postgresql.org/deve…
 
In this episode of Scaling Postgres, we discuss full text search, a process for query optimization, caution with exception blocks and adding a procedural language. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.youtube.com/watch?v=c8IrUHV70KQ https://fosdem.org/2020/schedule/event/p…
 
In this episode of Scaling Postgres, we discuss the "Ballad of Bloat", options for auditing, a configuration help resource and determining when a vacuum is needed. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.youtube.com/watch?v=2NxIngqq1y0 https://www.cybertec-postgresql.com/en/r…
 
In this episode of Scaling Postgres, we discuss storing non-relational data, recognizing contributors, Postgres security features and implementing high availability. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.enterprisedb.com/blog/8-ways-rdbms-postgres-handles-non-relational-dat…
 
In this episode of Scaling Postgres, we discuss tips & tricks, how to get faster APIs, full text search considerations and pgbouncer_fdw. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/tips-and-tricks-to-kick-start-postgres-year-2020/ https://goiabada.blog…
 
In this episode of Scaling Postgres, we discuss user account configuration, pricing, the system identifier and the HyperLogLog extension. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://tightlycoupled.io/my-goto-postgres-configuration-for-web-services/ https://medium.com/@rbranson/rds-pr…
 
In this episode of Scaling Postgres, we discuss max_locks_per_transaction, logical replication, managing backup & recovery and pgbouncer connection pooling. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/postgresql-you-might-need-to-increase-max_locks_per_…
 
In this episode of Scaling Postgres, we discuss the State of Postgres, how best to dump your database, setting configuration parameters and managing partial WAL files. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://stateofpostgres.com/ https://xzilla.net//blog/2019/Dec/5-Quick-Thoughts-…
 
In this episode of Scaling Postgres, we discuss logical replication aspects, how to monitor queries, investigating a SQL beautifier and removing incomplete startup packet. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1998/ https://rafiasabih.blogspot.com/…
 
In this episode of Scaling Postgres, we discuss book sales, boosts to b-tree indexes, more Postgres 12 features and how to setup and use pgBackRest. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://sql-performance-explained.com/ https://theartofpostgresql.com/blog/2019-11-black-friday/ ht…
 
In this episode of Scaling Postgres, we discuss global indexes, ways to cache aggregates, how vacuum processing works and the purpose of effective cache size. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.percona.com/blog/2019/11/20/proposal-for-global-indexes-in-postgresql/ https:…
 
In this episode of Scaling Postgres, we discuss chaos order, pub sub, petabyte scale analytics and PgBouncer connections. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1994/ https://www.simplethread.com/chaos-order-randomizing-queries-uncover-order-depende…
 
In this episode of Scaling Postgres, we discuss Postgres 12 performance impressions, mystery solving, GiST and SP-GiST performance and k-anonymity. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/postgresql-v12-initial-query-performance-impressions/ http://…
 
In this episode of Scaling Postgres, we discuss partitioning, logical replication upgrades, columnar compression and HAProxy connections. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.2ndquadrant.com/en/blog/webinar-postgresql-partitioning-follow-up/ https://www.cybertec-postgresql…
 
In this episode of Scaling Postgres, we discuss the benefits of pg_receivewal, how to setup simple application failover, new pg_checksums and setting up pgBouncer. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/never-lose-a-postgresql-transaction-with-pg_r…
 
In this episode of Scaling Postgres, we discuss prewarming your cache, working with nondeterministic collations, generated column performance and foreign keys with partitions. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/prewarming-postgresql-i-o-caches/…
 
In this episode of Scaling Postgres, we discuss changes to recovery configuration, the alter system command, transaction isolation and vacuum for temp tables. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.2ndquadrant.com/en/blog/replication-configuration-changes-in-postgresql-12/ h…
 
In this episode of Scaling Postgres, we discuss the release features of Postgres 12, generated columns, parallel estimates and change data capture. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1976/ https://www.enterprisedb.com/blog/8-major-improvements-p…
 
In this episode of Scaling Postgres, we discuss the release of Postgres 12, how to use window frames, the different index types, and when to use synchronous replication. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1975/ https://www.2ndquadrant.com/en/blo…
 
In this episode of Scaling Postgres, we discuss faster partition performance, count speed, extensions and Postgres education. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.2ndquadrant.com/en/blog/postgresql-12-partitioning/ https://blog.jooq.org/2019/09/19/whats-faster-count-or-cou…
 
In this episode of Scaling Postgres, we discuss data loading speeds, view dependencies, users & roles and high availability clusters. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: http://blog.coelho.net/database/2019/09/13/postgresql-vs-timescaledb-data-loading-performance.html https://docs.ti…
 
In this episode of Scaling Postgres, we discuss why you should just upgrade, vacuum updates in Postgres 12, psql connection strings and a Postgres showcase. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://info.crunchydata.com/blog/just-upgrade-how-postgresql-12-can-improve-your-performan…
 
In this episode of Scaling Postgres, we discuss PgBouncer SCRAM support, The Art of PostgreSQL, making Postgres a distributed time-series DB and window functions. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://pgbouncer.github.io/2019/08/pgbouncer-1-11-0 https://theartofpostgresql.com/ …
 
In this episode of Scaling Postgres, we discuss efficient pagination, how to rotate passwords, BRIN benefits and Row Level Security. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://engineering.shopify.com/blogs/engineering/pagination-relative-cursors https://www.jannikarndt.de/blog/2018/…
 
In this episode of Scaling Postgres, we discuss timeseries queries, using arrays with queries, range use cases and developing triggers in C. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/postgresql-trivial-timeseries-examples/ https://www.cybertec-postgre…
 
In this episode of Scaling Postgres, we discuss new CVEs, programming Postgres, JSONB comparison and using advisory locks. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1960/ https://www.2ndquadrant.com/en/blog/postgres-is-the-coolest-database-reason-5-it-…
 
In this episode of Scaling Postgres, we discuss combining indexes, regular expressions, parallelism in Postgres and PostGIS content. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/combined-indexes-vs-separate-indexes-in-postgresql/ https://www.2ndquadrant.…
 
In this episode of Scaling Postgres, we discuss vacuum through pictures, upcoming recovery changes, certification authentication and how functions get replicated. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.2ndquadrant.com/en/blog/postgresql-award/ https://www.2ndquadrant.com/en/…
 
In this episode of Scaling Postgres, we discuss BRIN indexes, partition enhancements, general tips and standby scaling. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.percona.com/blog/2019/07/16/brin-index-for-postgresql-dont-forget-the-benefits/ https://www.2ndquadrant.com/en/blog/…
 
In this episode of Scaling Postgres, we discuss collation issues, how to load data quickly, recovery changes in Postgres 12 and moving to SCRAM authentication. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/icu-collations-against-glibc-2-28-data-corruption…
 
In this episode of Scaling Postgres, we discuss indexing documents, how GIN indexes work, using Postgres for Data Science and generated columns. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://pgsnake.blogspot.com/2019/06/indexing-documents-for-full-text-search.html http://www.louisemeta…
 
In this episode of Scaling Postgres, we discuss the default security, max_connections and pooling, progress reporting and migrating to Postgres. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://info.crunchydata.com/blog/postgresql-defaults-and-impact-on-security-part-1 https://info.crunch…
 
In this episode of Scaling Postgres, we discuss performance training, SQL/JSON path support, hypothetical indexes and linear interpolation of data. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1949/ https://info.crunchydata.com/blog/explaining-cve-2019-10…
 
In this episode of Scaling Postgres, we discuss prepared plans, materialization, recursive CTEs and how to run safe database migrations. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/tech-preview-how-postgresql-12-handles-prepared-plans/ https://www.cyber…
 
In this episode of Scaling Postgres, we discuss videos from PGCon, Postgres tips & tricks, PostGIS parallel performance and using strings. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.youtube.com/channel/UCer4R0y7DrLsOXo-bI71O6A/videos https://www.youtube.com/user/PerconaMySQL/vid…
 
In this episode of Scaling Postgres, we discuss different query optimizations, normalizing to save space, visualizing vacuum and shardings future. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1943/ https://parallelthoughts.xyz/2019/05/a-tale-of-query-opti…
 
In this episode of Scaling Postgres, we discuss multi-column indexes, using multiple databases, Postgres dos & don'ts as well as using RUM indexes. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://medium.com/pgmustard/multi-column-indexes-4d17bac764c5 https://www.citusdata.com/blog/2019/0…
 
In this episode of Scaling Postgres, we discuss leveraging indexes, a slug function, addresses and security definer in functions. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1939/ https://pgdash.io/blog/postgres-indexes.html https://www.kdobson.net/2019/…
 
In this episode of Scaling Postgres, we review articles covering how to identify slow queries, the pg_auto_failover utility, working with roles and Hyperscale. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://dev.to/pythonmeister/how-to-identify-slow-queries-in-postgresql-4igk https://clo…
 
In this episode of Scaling Postgres, we review articles covering the index include clause, exporting data to CSV, using JSON in Postgres and Zedstore. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://use-the-index-luke.com/blog/2019-04/include-columns-in-btree-indexes https://phili.pe/pos…
 
In this episode of Scaling Postgres, we review articles covering constraint triggers, simple shards, data streams and OIDs. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/triggers-to-enforce-constraints/ https://www.youtube.com/watch?v=5sc_zoyDhwg https://…
 
In this episode of Scaling Postgres, we review articles covering pluggable storage, gotchas for developers, using cursors and new PG12 features. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.2ndquadrant.com/en/blog/around-world-two-billion-transactions/ https://www.youtube.com/watc…
 
In this episode of Scaling Postgres, we review articles covering Posgres' popularity, conducting load testing, checksums in PG12 and pg_hba configuration. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://blog.2ndquadrant.com/postgres-coolest-database-reason-1-developers-love/ https://www.…
 
In this episode of Scaling Postgres, we review articles covering security concerns, fast counting tables, indexing basics and PostgreSQL trends. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1935/ https://blog.hagander.net/when-a-vulnerability-is-not-a-vul…
 
In this episode of Scaling Postgres, we review articles covering checking on vacuum, how to get a fast distinct count and speed up group by and a health check playbook. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://medium.com/gett-engineering/scaling-postgresql-check-your-vacuum-f03092…
 
In this episode of Scaling Postgres, we review articles covering practical indexing, vertical scalability, migrating to partitions and foreign data wrapper performance. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://thebuild.com/presentations/look-it-up-pgday-nordic-2019.pdf https://pgd…
 
In this episode of Scaling Postgres, we review articles covering methods to replicate data, SQL functions, tools for high availability and locking issues. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://severalnines.com/blog/how-replicate-postgresql-data-remote-sites https://www.cybertec…
 
In this episode of Scaling Postgres, we review articles covering index-only scans, locking tables, hot standby feedback and handling very large backups. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://scalegrid.io/blog/2019-database-trends-sql-vs-nosql-top-databases-single-vs-multiple-da…
 
Loading …
Google login Twitter login Classic login