))
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.
S
Scaling Postgres
1
Episode 161 Scaling Lessons | Synchronous Commit | Connection Management | BLOB Cleanup
18:12
18:12
Play later
Play later
Lists
Like
Liked
18:12
In this episode of Scaling Postgres, we discuss 5 years of scaling lessons, working with synchronous commit, managing connections and cleaning up BLOBs. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://onesignal.com/blog/lessons-learned-from-5-years-of-scaling-postgresql/ https://momjian.…
S
Scaling Postgres
1
Episode 160 psql Tips | Postgres 13 Upgrade | Roles Hierarchy | Replica Scaling
9:10
9:10
Play later
Play later
Lists
Like
Liked
9:10
In this episode of Scaling Postgres, we discuss tips for using psql, stories from a Postgres 13 upgrade, exploring the role hierarchy and replica scaling considerations. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://mydbanotebook.org/psql_tips_all.html https://blog.discourse.org/2021/0…
S
Scaling Postgres
1
Episode 159 Tablespaces | Streaming Replication | More Postgres 14 | Security
9:33
9:33
Play later
Play later
Lists
Like
Liked
9:33
In this episode of Scaling Postgres, we discuss when to use tablespaces, setting up streaming replication, features coming in Postgres 14 and implementing security. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/when-to-use-tablespaces-in-postgresql/ https…
S
Scaling Postgres
1
Episode 158 Vacuum Speed Up | Faster Foreign Tables | Fast Queries With Union | Query Optimizer
19:49
19:49
Play later
Play later
Lists
Like
Liked
19:49
In this episode of Scaling Postgres, we discuss a vacuum speed up and faster foreign tables in Postgres 14, running faster queries with union and learning about the query optimizer. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.citusdata.com/blog/2021/03/25/speeding-up-recovery-and…
S
Scaling Postgres
1
Episode 157 auto_explain Overhead | Postgres Data Lake | Citus Shard Rebalance | SSL Authentication
18:41
18:41
Play later
Play later
Lists
Like
Liked
18:41
In this episode of Scaling Postgres, we discuss auto_explain's overhead, setting up a Postgres data lake, rebalancing a Citus shared database and implementing SSL authentication. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.pgmustard.com/blog/auto-explain-overhead-with-timing http…
S
Scaling Postgres
1
Episode 156 Columnar Storage | Docker Containers | Notify & Listen | Tuning RHEL
16:53
16:53
Play later
Play later
Lists
Like
Liked
16:53
In this episode of Scaling Postgres, we discuss Citus 10 columnar storage, using Postgres in docker containers, using notify & listen for real-time apps and tuning RHEL. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.citusdata.com/blog/2021/03/06/citus-10-columnar-compression-for-po…
S
Scaling Postgres
1
Episode 155 Citus Open Source | Time Series Performance | Subscripting Updates | target_session_attrs
17:17
17:17
Play later
Play later
Lists
Like
Liked
17:17
In this episode of Scaling Postgres, we discuss Citus 10 open source, time series performance in native Postgres, using subscripting for updates and new target_session_attrs. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.citusdata.com/blog/2021/03/05/citus-10-release-open-source-re…
S
Scaling Postgres
1
Episode 154 Connection Queuing | Connection Pool Size | Simple Audting | Fuzzy Matching
19:25
19:25
Play later
Play later
Lists
Like
Liked
19:25
In this episode of Scaling Postgres, we discuss connection queuing, estimating connection pools size, how to do simple auditing and how to run queries using fuzzy matching. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.percona.com/blog/2021/02/26/connection-queuing-in-pgbouncer-is-…
S
Scaling Postgres
1
Episode 153 Int to BigInt | Resistance is Futile | Optimizer Statistics | Advanced Query Optimization
12:25
12:25
Play later
Play later
Lists
Like
Liked
12:25
In this episode of Scaling Postgres, we discuss how to convert an integer primary key to a bigint, how container resistance is futile, how the optimizer uses statistics and how to set manual statistics. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.youtube.com/watch?v=aVty0_qcPzM h…
S
Scaling Postgres
1
Episode 152 New Releases | Reconnect After Failure | Bablefish | Troubleshoot Disk & Memory
15:33
15:33
Play later
Play later
Lists
Like
Liked
15:33
In this episode of Scaling Postgres, we discuss new PostgreSQL releases, reconnecting after a connection failure, Babelfish SQL Server compatibility and troubleshooting disk and memory issues. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/postgresql-132-12…
S
Scaling Postgres
1
Episode 151 Cleaning Up | Function Performance | 11 Million IOPS | Change Data Capture
18:11
18:11
Play later
Play later
Lists
Like
Liked
18:11
In this episode of Scaling Postgres, we discuss cleaning up your database, function performance, 11 million IOPS and change data capture. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://hakibenita.com/postgresql-unused-index-size https://info.crunchydata.com/blog/cleaning-up-your-postgre…
S
Scaling Postgres
1
Episode 150 Scaling Advice | Vicious Cycle | Improve Observability | Addressing Corruption
16:57
16:57
Play later
Play later
Lists
Like
Liked
16:57
In this episode of Scaling Postgres, we discuss scaling advice, a vicious cycle of WAL writes, how to improve observability and addressing database corruption. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/postgres-scaling-advice-for-2021/ https://mydbano…
S
Scaling Postgres
1
Episode 149 ARM Tests | Tips & Tricks | Hierarchical Structures | Benchmarking Framework
12:24
12:24
Play later
Play later
Lists
Like
Liked
12:24
In this episode of Scaling Postgres, we discuss tests of Postgres on ARM processors, 2021 tips & tricks, working with hierarchical structures and creating a benchmarking framework. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.percona.com/blog/2021/01/22/postgresql-on-arm-based-aws…
S
Scaling Postgres
1
Episode 148 Hash Indexes | Int Float Numeric Types | Postgres 14 Features | Data Science
11:55
11:55
Play later
Play later
Lists
Like
Liked
11:55
In this episode of Scaling Postgres, we discuss hash indexes, the int, float and numeric data types, features coming in Postgres 14 and data science in Postgres. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://hakibenita.com/postgresql-hash-index https://www.cybertec-postgresql.com/en/po…
S
Scaling Postgres
1
Episode 147 DBMS of the Year | Better Data Migrations | Idle Connection Impact | Security Implementation Guide
20:29
20:29
Play later
Play later
Lists
Like
Liked
20:29
In this episode of Scaling Postgres, we discuss PostgreSQL as the DBMS of the year, running better data migrations, the impact of idle connections and a security implementation guild. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://db-engines.com/en/blog_post/85 https://medium.com/doctol…
S
Scaling Postgres
1
Episode 146 Active-Active & Federated | Memory Speed | Table Rewrite Causes | PostgreSQL Shibboleth
14:46
14:46
Play later
Play later
Lists
Like
Liked
14:46
In this episode of Scaling Postgres, we discuss setting up active-active instances with federation, the impact of memory speed, the causes of table rewrites and the Postgres shibboleth. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://info.crunchydata.com/blog/active-active-postgres-feder…
S
Scaling Postgres
1
Episode 145 PgMiner Botnet | Collation Index Corruption | postgresql.conf | Custom Data Types
14:07
14:07
Play later
Play later
Lists
Like
Liked
14:07
In this episode of Scaling Postgres, we discuss the PGMiner botnet attack, how collation changes can cause index corruption, managing your postgresql.conf and implementing custom data types. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.zdnet.com/article/pgminer-botnet-attacks-weak…
S
Scaling Postgres
1
Episode 144 Postgres Migration | Bulk Data Loading | Updates vs. Upgrades | UUID Benchmarks
12:10
12:10
Play later
Play later
Lists
Like
Liked
12:10
In this episode of Scaling Postgres, we discuss a Mongo to Postgres migration, the best way to bulk load data, running an update vs. an upgrade and benchmarks for UUIDs. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://blog.coinbase.com/seamless-mongodb-to-postgresql-migration-127735cc989…
S
Scaling Postgres
1
Episode 143 Microsoft SQL Server Compatible | Time Series Performance | Feature Casualties | BLOB Cleanup
18:43
18:43
Play later
Play later
Lists
Like
Liked
18:43
In this episode of Scaling Postgres, we discuss Microsoft SQL server compatibility, the performance of time series DBs, DB feature casualties and how to clean up BLOBs. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.ongres.com/blog/aws_announces_open_source_postgres_with_sql_server_…
S
Scaling Postgres
1
Episode 142 Insert vs. Update | Select * Performance | Debezium Set Up | Standardizing Data
13:35
13:35
Play later
Play later
Lists
Like
Liked
13:35
In this episode of Scaling Postgres, we discuss inserts vs. updates, select * performance, how to set up Debezium and methods to standardize data. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/insert-only-data-modelling-to-smooth-peaks-on-slow-disks/ http…
S
Scaling Postgres
1
Episode 141 Unattended Upgrade | ARM Benchmarks | Exploration | PostGIS Performance
10:32
10:32
Play later
Play later
Lists
Like
Liked
10:32
In this episode of Scaling Postgres, we discuss an unattended upgrade, ARM Postgres benchmarks, how to explore new databases and PostGIS performance. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://seiler.us/2020-11-18-unattended-upgrades/ https://info.crunchydata.com/blog/postgresql-ben…
S
Scaling Postgres
1
Episode 140 Replication Conflicts | Postgres Governance | pg_crash | MobilityDB
11:28
11:28
Play later
Play later
Lists
Like
Liked
11:28
In this episode of Scaling Postgres, we discuss replication conflicts, how Postgres is governed, a pg_crash utility and tracking temporal spatial data with Mobility. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/postgresql-131-125-1110-1015-9620-and-9524-r…
S
Scaling Postgres
1
Episode 139 Weekly News | Full-Text Search Performance | pg_cron | Bulk Data Loading
12:38
12:38
Play later
Play later
Lists
Like
Liked
12:38
In this episode of Scaling Postgres, we discuss Postgres weekly news, full-text search performance, enhancements to pg_cron and the best way to bulk load data. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/new-postgresql-core-team-members-2103/ https://www…
S
Scaling Postgres
1
Episode 138 Scaling Connections | TimescaleDB | Time-series Gaps | Red & Golden Signals
16:57
16:57
Play later
Play later
Lists
Like
Liked
16:57
In this episode of Scaling Postgres, we discuss scaling connections, the release of TimescaleDB 2.0, how to find time-series gaps and monitoring RED & Golden signals. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.citusdata.com/blog/2020/10/25/improving-postgres-connection-scalabili…
S
Scaling Postgres
1
Episode 137 Toast Impact | zheap Storage | More Performance | pg_rewind Changes
21:15
21:15
Play later
Play later
Lists
Like
Liked
21:15
In this episode of Scaling Postgres, we discuss the impact of toast, zheap storage results, more Postgres 13 performance data and changes to pg_rewind. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/statement-from-the-postgresql-core-team-on-the-edb-acquisi…
S
Scaling Postgres
1
Episode 136 Stat Tracking | Temporary Tables | pg_squeeze | pg_auto_failover
13:09
13:09
Play later
Play later
Lists
Like
Liked
13:09
In this episode of Scaling Postgres, we discuss stat tracking, temporary tables, a new utility called pg_squeeze and an update to pg_auto_failover. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://pgcraftsman.io/2020/10/15/tracking-postgres-stats/ https://www.cybertec-postgresql.com/en/po…
S
Scaling Postgres
1
Episode 135 Connection Scalability | Benchmarking Performance | Community Impact | zheap Progress
19:43
19:43
Play later
Play later
Lists
Like
Liked
19:43
In this episode of Scaling Postgres, we discuss connection scalability, benchmarking Postgres performance, the community impact of an acquisition and the progress of zheap. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.citusdata.com/blog/2020/10/08/analyzing-connection-scalability/…
S
Scaling Postgres
1
Episode 134 Community Acquisition | Space Saving Terabytes | WAL Archiving | Vacuum Analyze Tips
14:11
14:11
Play later
Play later
Lists
Like
Liked
14:11
In this episode of Scaling Postgres, we discuss a company acquisition within the Postgres community, how to save terabytes of space, setting up WAL archiving and vacuum/analyze tips. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.enterprisedb.com/news/edb-completes-acquisition-2ndqu…
S
Scaling Postgres
1
Episode 133 Postgres 13 Released | What's New In Postgres 13 | Debugging PL/PGSQL | Monitoring
13:54
13:54
Play later
Play later
Lists
Like
Liked
13:54
In this episode of Scaling Postgres, we discuss the release of Postgres 13, what is new in Postgres 13, how to debug PL/PGSQL and Postgres monitoring best practices. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/postgresql-13-released-2077/ https://pganaly…
S
Scaling Postgres
1
Episode 132 Postgres 13 RC1 | Upgrading at Scale | With Ties | HOT Updates
17:40
17:40
Play later
Play later
Lists
Like
Liked
17:40
In this episode of Scaling Postgres, we discuss the release of Postgres 13 RC1, how to upgrade Postgres at scale, using limit with ties and understanding Heap Only Tuple (HOT) updates. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/2072/ https://about.gitla…
S
Scaling Postgres
1
Episode 131 Slow Archival | Index Improvements | Node Metrics | Join or Subquery
15:59
15:59
Play later
Play later
Lists
Like
Liked
15:59
In this episode of Scaling Postgres, we discuss slow WAL archival, index improvements coming for Postgres 13, accessing node metrics via SQL and deciding between a join or subquery. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.percona.com/blog/2020/09/09/why-postgresql-wal-archiva…
S
Scaling Postgres
1
Episode 130 External Compression | Parallel Vacuum | JSON Aggregates | JSON & Arrays
15:16
15:16
Play later
Play later
Lists
Like
Liked
15:16
In this episode of Scaling Postgres, we discuss external compression, vacuuming in parallel, working with JSON Aggregates and the JSON & Array datatypes. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://amitdkhan-pg.blogspot.com/2020/08/need-for-external-compression-methods.html https://w…
S
Scaling Postgres
1
Episode 129 28 Tips | Lucky 13 | Autovacuum Tuning | Logical Pitfalls
15:59
15:59
Play later
Play later
Lists
Like
Liked
15:59
In this episode of Scaling Postgres, we discuss 28 tips & tricks, Postgres 13 is lucky, autovacuum tuning and logical replication pitfalls. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://pgdash.io/blog/postgres-tips-and-tricks.html https://info.crunchydata.com/blog/why-postgresql-13-is-…
S
Scaling Postgres
1
Episode 128 Statistics Speed Up | Synchronous Commits | TLS Updates | Avoiding Cursors
16:57
16:57
Play later
Play later
Lists
Like
Liked
16:57
In this episode of Scaling Postgres, we discuss speeding up performance with statistics, setting synchronous_commit, updates to TLS settings and how to avoid cursors. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://build.affinity.co/how-we-used-postgres-extended-statistics-to-achieve-a-3…
S
Scaling Postgres
1
Episode 127 Recursive Queries | Lateral Joins | Pagination | JSONB Arrays
14:38
14:38
Play later
Play later
Lists
Like
Liked
14:38
In this episode of Scaling Postgres, we discuss recursive queries, using lateral joins, paging through a data sets efficiently and working with JSONB arrays. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/2060/ https://www.cybertec-postgresql.com/en/recursi…
S
Scaling Postgres
1
Episode 126 BRIN Pitfalls | pg_stat_statement Troubleshooting | Natural Join | Geography Type
14:14
14:14
Play later
Play later
Lists
Like
Liked
14:14
In this episode of Scaling Postgres, we discuss BRIN pitfalls, using pg_stat_statements for troubleshooting, natural joins to detect duplicates and the geography type. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://info.crunchydata.com/blog/avoiding-the-pitfalls-of-brin-indexes-in-postg…
S
Scaling Postgres
1
Episode 125 Scaling Suggestions | Slot Safety | SCRAM Channel Binding | Effective Cache Size
15:01
15:01
Play later
Play later
Lists
Like
Liked
15:01
In this episode of Scaling Postgres, we discuss suggestions for scaling postgres, replication slots safety, implementing scram password authentication with channel binding and setting effective_cache_size. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://hakibenita.com/sql-tricks-applicat…
S
Scaling Postgres
1
Episode 124 Partition Migration | Like Performance | Best Fillfactor | In-Memory Tables
15:57
15:57
Play later
Play later
Lists
Like
Liked
15:57
In this episode of Scaling Postgres, we discuss how best to migrate to using partitions, like & ilike performance, determining the best fillfactor and the work towards in-memory tables. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.2ndquadrant.com/en/blog/partitioning-a-large-table…
S
Scaling Postgres
1
Episode 123 JSONB Types | Earth Distance | Dates, Times & Intervals | Authentication
13:29
13:29
Play later
Play later
Lists
Like
Liked
13:29
In this episode of Scaling Postgres, we discuss working with JSONB types, calculating earth distance, utilizing dates, times & intervals and Postgres authentication. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://momjian.us/main/blogs/pgblog/2020.html#July_13_2020 https://adamfallon.com…
S
Scaling Postgres
1
Episode 122 Postgres is Fine | Generated Columns | Postgres Inserts | Synchronous Replication
10:15
10:15
Play later
Play later
Lists
Like
Liked
10:15
In this episode of Scaling Postgres, we discuss determining if Postgres is fine, generated columns vs. triggers, insert features and synchronous replication usage. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.2ndquadrant.com/en/blog/its-the-end-of-the-world-as-we-know-it-and-postg…
S
Scaling Postgres
1
Episode 121 Fantastic Data Types | Domain Data Types | Insert Performance | Row Differences
16:34
16:34
Play later
Play later
Lists
Like
Liked
16:34
In this episode of Scaling Postgres, we discuss fantastic data types, custom domain data types, improving insert performance and how to query row differences. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.2ndquadrant.com/en/blog/webinar-fantastic-data-types-and-where-to-use-them-fo…
S
Scaling Postgres
1
Episode 120 Postgres 13 Beta 2 | System Stats Extension | Tuned | Join Strategy
12:13
12:13
Play later
Play later
Lists
Like
Liked
12:13
In this episode of Scaling Postgres, we discuss Postgres 13 Beta 2, a system stats extension, tuning your operating systems for Postgres and different join strategies. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/2047/ https://www.youtube.com/watch?v=G5f2…
S
Scaling Postgres
1
Episode 119 Replication Complications | One Word Performance | Pgbouncer Users | Serializable Isolation
15:06
15:06
Play later
Play later
Lists
Like
Liked
15:06
In this episode of Scaling Postgres, we discuss replication complications, adding one word to boost performance, handling pgbouncer users and serializable isolation testing. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.2ndquadrant.com/en/blog/pg-phriday-10-things-postgres-could-im…
S
Scaling Postgres
1
Episode 118 Safety Systems | Failover Slots | Transaction ID Complications | Repartitioning
15:52
15:52
Play later
Play later
Lists
Like
Liked
15:52
In this episode of Scaling Postgres, we discuss safety systems, the purpose and existence of failover slots, complications with transaction IDs and how to repartition without downtime. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://momjian.us/main/blogs/pgblog/2020.html#June_8_2020 http…
S
Scaling Postgres
1
Episode 117 Index Deduplication | Fast Hierarchy | More Monitoring | Cloud-Native
17:36
17:36
Play later
Play later
Lists
Like
Liked
17:36
In this episode of Scaling Postgres, we discuss index deduplication in Postgres 13, fast hierarchical access, more essential monitoring and cloud native Postgres. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/b-tree-index-deduplication/ https://www.cybert…
S
Scaling Postgres
1
Episode 116 Observer Effect | Partition Management | Tuple Freezing | Hung Transactions
14:02
14:02
Play later
Play later
Lists
Like
Liked
14:02
In this episode of Scaling Postgres, we discuss the observer effect with explain analyze, partition management, tuple freezing and sources of hung transactions. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.ongres.com/blog/explain_analyze_may_be_lying_to_you/ https://www.cybertec-p…
S
Scaling Postgres
1
Episode 115 PGCon Online | Performance Tips | Tracking Counts | Essential Monitoring
12:51
12:51
Play later
Play later
Lists
Like
Liked
12:51
In this episode of Scaling Postgres, we discuss PGCon going online, application performance tips, ways to track counts and essential areas to monitor. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/2040/ https://www.pgcon.org/2020/ https://www.citusdata.com…
S
Scaling Postgres
1
Episode 114 Data Directory | Vacuum Features | Binary Performance | Network Latency
20:29
20:29
Play later
Play later
Lists
Like
Liked
20:29
In this episode of Scaling Postgres, we discuss the Postgres data directory, new vacuum features, binary storage performance and the impact of network latency. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/2038/ https://people.planetpostgresql.org/devrim/i…
S
Scaling Postgres
1
Episode 113 arm64 with apt | Contributors | Backup Manifest | Now Functions
13:07
13:07
Play later
Play later
Lists
Like
Liked
13:07
In this episode of Scaling Postgres, we discuss arm64 package support for apt, annual Postgres contributors, backup manifests & verifications and different now functions. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: http://www.df7cb.de/blog/2020/arm64-on-apt.postgresql.org.html http://rhaas.b…
S
Scaling Postgres
1
Episode 112 Explain Analyze | Sequence Counts | Best Books | Partition Migration
16:45
16:45
Play later
Play later
Lists
Like
Liked
16:45
In this episode of Scaling Postgres, we discuss how to use explain analyze, the problem with counting sequences, the best books to learn Postgres and how to migrate to declarative partitioning. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.highgo.ca/2020/04/30/optimizing-sql-step-1…
