
Scaling Postgres
443 episodes — Page 8 of 9

Ep 93Logical Replication, Monitoring Queries, SQL Beautifier, Incomplete Startup Packet | Scaling Postgres 93
In this episode of Scaling Postgres, we discuss logical replication aspects, how to monitor queries, investigating a SQL beautifier and removing incomplete startup packet. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/93-logical-replication-monitoring-queries-sql-beautifier-incomplete-startup-packet/

Ep 92Book Sales, B-tree Boost, More Postgres 12, Using pgBackRest | Scaling Postgres 92
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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/92-book-sales-btree-boost-more-postgres-12-using-pgbackrest/

Ep 91Global Indexes, Caching Aggregates, Vacuum Processing, Effective Cache Size | Scaling Postgres 91
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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/91-global-indexes-caching-aggregates-vacuum-processing-effective-cache-size/

Ep 90Chaos Order, Pub Sub, Petabyte Scale, PgBouncer Connections | Scaling Postgres 90
In this episode of Scaling Postgres, we discuss chaos order, pub sub, petabyte scale analytics and PgBouncer connections. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/90-chaos-order-pub-sub-petabyte-scale-pgbouncer-connections/

Ep 89Performance Impressions, Mystery Solving, GiST Performance, K-Anonymity | Scaling Postgres 89
In this episode of Scaling Postgres, we discuss Postgres 12 performance impressions, mystery solving, GiST and SP-GiST performance and k-anonymity. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/89-performance-impressions-mystery-solving-gist-performance-k-anonymity/

Ep 88Partitioning, Logical Replication Upgrade, Columnar Compression, HAProxy Connections | Scaling Postgres 88
In this episode of Scaling Postgres, we discuss partitioning, logical replication upgrades, columnar compression and HAProxy connections. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/88-partitioning-logical-replication-upgrade-columnar-compression-haproxy-connections/

Ep 87pg_receivewal, Application Failover, pg_checksums, pgBouncer | Scaling Postgres 87
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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/87-pg_receivewal-application-failover-pg_checksums-pgbouncer/

Ep 86Prewarming, Nondeterministic Collations, Generated Column Performance, Foreign Keys | Scaling Postgres 86
In this episode of Scaling Postgres, we discuss prewarming your cache, working with nondeterministic collations, generated column performance and foreign keys with partitions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/86-prewarming-nondeterministic-collations-generated-column-performance-foreign-keys/

Ep 85Recovery Configuration, Alter System, Transaction Isolation, Temp Table Vacuum | Scaling Postgres 85
In this episode of Scaling Postgres, we discuss changes to recovery configuration, the alter system command, transaction isolation and vacuum for temp tables. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/85-recovery-configuration-alter-system-transaction-isolation-temp-table-vacuum/

Ep 84Postgres 12 Released, Generated Columns, Parallel Estimates, Change Data Capture | Scaling Postgres 84
In this episode of Scaling Postgres, we discuss the release features of Postgres 12, generated columns, parallel estimates and change data capture. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/84-postgres-12-released-generated-columns-parallel-estimates-change-data-capture/

Ep 83Postgres 12, Window Frames, Index Types, Synchronous Replication | Scaling Postgres 83
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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/83-postgres-12-window-frames-index-types-synchronous-replication/

Ep 82Faster Partitions, Count Speed, Extensions, Education | Scaling Postgres 82
In this episode of Scaling Postgres, we discuss faster partition performance, count speed, extensions and Postgres education. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/82-faster-partitions-count-speed-extensions-education/

Ep 81Data Loading Speed, View Dependencies, Users & Roles, H/A Clusters | Scaling Postgres 81
In this episode of Scaling Postgres, we discuss data loading speeds, view dependencies, users & roles and high availability clusters. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/81-data-loading-speed-view-dependencies-users-roles-high-availability-clusters/

Ep 80Just Upgrade, Vacuum Updates, Connection Strings, Postgres Showcase | Scaling Postgres 80
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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/80-just-upgrade-vacuum-updates-connection-strings-postgres-showcase/

Ep 79PgBouncer SCRAM, Art of PostgreSQL, Distributed Time-Series, Window Functions | Scaling Postgres 79
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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/79-pgbouncer-scram-art-of-postgresql-distributed-time-series-window-functions/

Ep 78Efficient Pagination, Rotating Passwords, BRIN, Row Level Security | Scaling Postgres 78
In this episode of Scaling Postgres, we discuss efficient pagination, how to rotate passwords, BRIN benefits and Row Level Security. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/78-efficient-pagination-rotating-passwords-brin-row-level-security/

Ep 77Timeseries Queries, Arrays, Ranges, C Triggers | Scaling Postgres 77
In this episode of Scaling Postgres, we discuss timeseries queries, using arrays with queries, range use cases and developing triggers in C. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/77-timeseries-queries-arrays-ranges-c-triggers/

Ep 76New CVEs, Postgres Programming, JSONB, Advisory Locks | Scaling Postgres 76
In this episode of Scaling Postgres, we discuss new CVEs, programming Postgres, JSONB comparison and using advisory locks. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/76-new-cves-postgres-programming-jsonb-advisory-locks/

Ep 75Combining Indexes, Regular Expressions, Parallelism, PostGIS | Scaling Postgres 75
In this episode of Scaling Postgres, we discuss combining indexes, regular expressions, parallelism in Postgres and PostGIS content. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/75-combining-indexes-regular-expressions-parallelism-postgis/

Ep 74Picturing Vacuum, Recovery Changes, Cert Authentication, Function Replication | Scaling Postgres 74
In this episode of Scaling Postgres, we discuss vacuum through pictures, upcoming recovery changes, certification authentication and how functions get replicated. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/74-picturing-vacuum-recovery-changes-certificate-authentication-function-replication/

Ep 73BRIN Indexes, Partition Enhancements, Tips, Standbys | Scaling Postgres 73
In this episode of Scaling Postgres, we discuss BRIN indexes, partition enhancements, general tips and standby scaling. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/73-brin-indexes-partition-enhancements-tips-standbys/https://www.scalingpostgres.com/episodes/73-brin-indexes-partition-enhancements-tips-standbys/

Ep 72Collation Issues, Fast Loading, Recovery, SCRAM Authentication | Scaling Postgres 72
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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/72-collation-issues-fast-loading-recovery-scram-authentication/

Ep 71Indexing Documents, GIN Indexes, Data Science, Generated Columns | Scaling Postgres 71
In this episode of Scaling Postgres, we discuss indexing documents, how GIN indexes work, using Postgres for Data Science and generated columns. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/71-indexing-documents-gin-indexes-data-science-generated-columns/

Ep 70Default Security, Max Connections, Progress Reporting, Migration | Scaling Postgres 70
In this episode of Scaling Postgres, we discuss the default security, max_connections and pooling, progress reporting and migrating to Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/70-default-security-max-connections-progress-reporting-migration/

Ep 69Performance Training, JSON Path, Hypothetical Indexes, Interpolation | Scaling Postgres 69
In this episode of Scaling Postgres, we discuss performance training, SQL/JSON path support, hypothetical indexes and linear interpolation of data. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/69-performance-training-json-path-hypothetical-indexes-interpolation/

Ep 68Prepared Plans, Materialization, Recursive CTEs, Safe Migrations | Scaling Postgres 68
In this episode of Scaling Postgres, we discuss prepared plans, materialization, recursive CTEs and how to run safe database migrations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/68-prepared-plans-materialization-recursive-cte-safe-migrations/

Ep 67PGCon, Tips, PostGIS, Strings | Scaling Postgres 67
In this episode of Scaling Postgres, we discuss videos from PGCon, Postgres tips & tricks, PostGIS parallel performance and using strings. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/67-pgcon-tips-postgis-strings/

Ep 66Query Optimization, Normalization, Visualizing Vacuum, Sharding | Scaling Postgres 66
In this episode of Scaling Postgres, we discuss different query optimizations, normalizing to save space, visualizing vacuum and shardings future. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/66-query-optimization-normalization-visualizing-vacuum-sharding/

Ep 65Multi Column, Multi DB, Dos & Don'ts, RUM Indexes | Scaling Postgres 65
In this episode of Scaling Postgres, we discuss multi-column indexes, using multiple databases, Postgres dos & don'ts as well as using RUM indexes. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/65-multi-column-multi-db-dos-and-donts-rum-indexes/

Ep 64Leveraging Indexes, Slugs, Addresses, Security Definer | Scaling Postgres 64
In this episode of Scaling Postgres, we discuss leveraging indexes, a slug function, addresses and security definer in functions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/64-leveraging-indexes-slugs-addresses-security-definer/

Ep 63Slow Queries, pg_auto_failover, Roles, Hyperscale | Scaling Postgres 63
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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/63-slow-queries-pg_auto_failover-roles-hyperscale/

Ep 62Index Include Clause, Exporting CSV, JSON, Zedstore | Scaling Postgres 62
In this episode of Scaling Postgres, we review articles covering the index include clause, exporting data to CSV, using JSON in Postgres and Zedstore. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/62-index-include-clause-exporting-csv-json-zedstore/

Ep 61Constraint Triggers, Simple Shards, Data Streams, OIDs | Scaling Postgres 61
In this episode of Scaling Postgres, we review articles covering constraint triggers, simple shards, data streams and OIDs. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/61-constraint-triggers-simple-shards-data-streams-oids/

Ep 60Pluggable Storage, Developer Gotchas, Cursors, PG12 | Scaling Postgres 60
In this episode of Scaling Postgres, we review articles covering pluggable storage, gotchas for developers, using cursors and new PG12 features. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/60-pluggable-storage-developer-gotchas-cursors-pg12/

Ep 59Popularity, Load Testing, Checksums, pg_hba | Scaling Postgres 59
In this episode of Scaling Postgres, we review articles covering Posgres' popularity, conducting load testing, checksums in PG12 and pg_hba configuration. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/59-popularity-load-testing-checksums-pg_hba/https://www.scalingpostgres.com/episodes/59-popularity-load-testing-checksums-pg_hba/

Ep 58Security Concerns, Fast Counting, Indexing, Trends | Scaling Postgres 58
In this episode of Scaling Postgres, we review articles covering security concerns, fast counting tables, indexing basics and PostgreSQL trends. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/58-security-concerns-fast-counting-indexing-trends/

Ep 57Checking Vacuum, Fast Distinct Count, Group By Speed Up, Health Check | Scaling Postgres 57
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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/57-checking-vacuum-fast-distinct-count-group-by-speed-up-health-check/

Ep 56Practical Indexing, Vertical Scaling, Partition Migration, FDW Performance | Scaling Postgres 56
In this episode of Scaling Postgres, we review articles covering practical indexing, vertical scalability, migrating to partitions and foreign data wrapper performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/56-practical-indexing-vertical-scaling-partition-migration-fdw-performance/

Ep 55Replicating Data, SQL Functions, High Availability, Locking Issues | Scaling Postgres 55
In this episode of Scaling Postgres, we review articles covering methods to replicate data, SQL functions, tools for high availability and locking issues. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/55-replicating-data-sql-functions-high-availability-locking-issues/

Ep 54Index-Only Scans, Lock Table, Hot Standby Feedback, Large Backups | Scaling Postgres 54
In this episode of Scaling Postgres, we review articles covering index-only scans, locking tables, hot standby feedback and handling very large backups. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/54-index-only-scans-lock-table-hot-standby-feedback-large-backups/

Ep 53Query Planner, BRIN Indexes, Approximate Algorithms, Delayed Replication | Scaling Postgres 53
In this episode of Scaling Postgres, we review articles covering the Postgres query planner, BRIN indexes, approximate algorithms, and the uses of delayed replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/53-query-planner-brin-indexes-approximate-algorithms-delayed-replication/

Ep 52fsync Stopgap, CTE Changes, autovacuum_naptime, Postgres Community | Scaling Postgres 52
In this episode of Scaling Postgres, we review articles covering a fsync stopgap, tuning autovacuum_naptime, upcoming CTE / WITH clause changes and the Postgres community. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/52-fsync-stopgap-autovacuum_naptime-cte-changes-postgres-community/

Ep 51Value of SQL, Window Functions, DB Migrations, Data Storage | Scaling Postgres 51
In this episode of Scaling Postgres, we review articles covering the value of SQL, window functions, scaling database migrations and efficient data storage. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/51-sql-value-window-functions-db-migrations-data-storage/

Ep 50Outage from TXIDs, Breaking Scale, fsync Gate, pg_stat_statements | Scaling Postgres 50
In this episode of Scaling Postgres, we review articles covering an outage from running out of TXIDs, breaking scale, that PG fsync issue and pg_stat_statements. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/50-outage-txids-breaking-scale-fsync-gate-pg_stat_statements/

Ep 49Over One Billion, No Downtime, SQL Life, Throughput | Scaling Postgres 49
In this episode of Scaling Postgres, we review articles covering over one billion records per month, schema changes with no downtime, the life of a SQL query and throughput tracking. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/49-over-one-billion-monthly-records-no-downtime-schema-changes-sql-life-throughput-tracking/

Ep 48Microsoft Acquires Citus Data, Split WAL, Maintenance Work Mem | Scaling Postgres 48
In this episode of Scaling Postgres, we review articles covering Microsoft acquiring Citus Data, split WAL files, maintenance_work_mem and logical replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/48-microsoft-acquires-citus-data-split-wal-maintenance-work-memory-logical-replication/

Ep 47pgBouncer, Postgres 11 Gems, DocumentDB, JSON | Scaling Postgres 47
In this episode of Scaling Postgres, we review articles covering pgBouncer, Postgres 11 gems, DocumentDB similarities and JSON capabilities. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/47-pgbouncer-postgres-11-gems-documentdb-json/

Ep 46Stuck Transaction IDs, pgBouncer Auth, UUIDs, Monitoring | Scaling Postgres 46
In this episode of Scaling Postgres, we review articles covering stuck transaction ids, pgBouncer authentication, sequential UUIDs, and monitoring. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/46-stuck-transaction-ids-pgbouncer-authentication-uuids-monitoring/

Ep 45DBMS of 2018, Data Anonymization, JIT, Reserved Keywords | Scaling Postgres 45
In this episode of Scaling Postgres, we review articles covering Postgres as DBMS of 2018, data anonymization, implementing JIT and reserved keywords. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/45-dmbs-2018-data-anonymization-jit-reserved-keywords/

Ep 44Postgres Rise, Row Count Estimates, Nulls, Linux Config | Scaling Postgres 44
In this episode of Scaling Postgres, we review articles covering the rise of Postgres, row count estimates, nulls and linux configuration. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/44-postgres-rise-row-count-estimates-nulls-linux-config/