Scaling Postgres
Episodes
Planner Optimization, Fish to Elephants, Large Databases, Spatial Data | Scaling Postgres 213
01 May 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss ways you can optimize the planner, becoming part of the Postgres Community, considerations for large d...
Slow Queries, 4TB Upgrade, Postgres on ZFS, Storage Stampede | Scaling Postgres 212
24 Apr 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss dealing with slow queries, upgrading a 4TB database, running Postgres on ZFS and handling a storage st...
Multiranges, Missing Metrics, Newbie PostGIS, Conference Videos | Scaling Postgres 211
17 Apr 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss working with multiranges, missing Postgres metrics, PostGIS for newbies and videos from CitusCon. To g...
Date Time Bins, Search Every Field, JSON_TABLE, Picking Primary | Scaling Postgres 210
10 Apr 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how to bin date times, search every field of a table, use JSON_TABLE and methods for a client to pick ...
Tidy Vacuum, Dropping Roles, Merge Command, PgBouncer Tutorial | Scaling Postgres 209
03 Apr 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how to optimize vacuum, how to drop roles, the new merge command in PG15 and a pgbouncer tutorial. To ...
pgbouncer Released, Query Parameter Types, Lateral Joins, Security Invoker Views | Scaling Postgres 208
27 Mar 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a new version of pgbouncer, query parameter types, a performance improvement from a lateral join and s...
Autovacuum Configuration, Duplicate Key Violations, Pipelining, Tuning max_wal_size | Scaling Postgres 207
20 Mar 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how best to configure autovacuum, the dangers of duplicate key violations, how to set up pipelining, a...
100x Optimizations, Auditing, Document Schema Designs, Checksums | Scaling Postgres 206
13 Mar 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss 100x optimizations, how to audit table activity, designing schemas and how to set up table checksums. ...
Indexing With tsearch, Tuples Not Yet Removable, Wicked Problems, Pattern Matching | Scaling Postgres 205
07 Mar 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the best ways to index with tsearch, what to check if tuples are not yet removable, wicked problems wi...
Optimizing Trigram Search, Replication Review, Logical Improvements, Timescale Investment | Scaling Postgres 204
27 Feb 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss optimizing trigram searches, a review of Postgres replication, improvements to logical replication and...
Saving Space, Working with TOAST, Protecting Data, High CPU Utilization | Scaling Postgres 203
20 Feb 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go faster and us...
New Postgres Releases, A Hairy Incident, Slow Down To Go Faster, Loadable Module Archiving | Scaling Postgres 202
14 Feb 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go faster and us...
JSONB Performance, Bidirectional Replication, Most Recent Record, PG14 JSON | Scaling Postgres 201
07 Feb 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss JSONB performance, bidirectional replication, getting the most recent record and using JSON in Postgre...
5 Minutes of Postgres, Unnest, SCRAM, Multi-master Review | Scaling Postgres 200
30 Jan 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the new series 5 minutes of Postgres, using unnest, switching to SCRAM authentication and reviewing mu...
Shaped Sample Data, Version Changes, Missed Bottlenecks, Indexes for Newbies | Scaling Postgres 199
24 Jan 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how to generate shaped sample data, track changes between Postgres versions, identify missed bottlenec...
Monitoring Progress, More SQL, Replication Slot Failover, Postgres Contributors | Scaling Postgres 198
16 Jan 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how to monitor DML & DDL progress, using more SQL, one way to handle replication slot fail-over, a...
Explain Analyze Buffers, Healthier Postgres, 2021 Review, High Availability Aspirations | Scaling Postgres 197
09 Jan 2022
Contributed by Lukas
In this episode of Scaling Postgres, we discuss including buffers with explain analyze, having a healthier Postgres DB, the events of 2021 and aspirin...
Easy Recursive CTE, Zheap Undo, High Availability, Loading Data | Scaling Postgres 196
19 Dec 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss easily writing a recursive CTE, the zheap undo capability, high availability considerations and fast w...
Aurora vs. Postgres, Surprising Transactions, Write-Only & Read-Only, Indexing Advice | Scaling Postgres 195
13 Dec 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss Aurora vs. Postgres, surprising transaction behavior, write-only & read-only database connections ...
Go Faster, GIN Indexes, Collation Stability, PG14 & Beyond | Scaling Postgres 194
10 Dec 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss going slower to go faster, GIN indexes, collation stability and features of PG14 and beyond. To get th...
Entity-Attribute-Value Design, JSON Subscripting, mysql-fdw Push-down, New Regex | Scaling Postgres 193
28 Nov 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss using entity-attribute-value designs, new JSON subscripting capabilities, the mysql-fdw support for ag...
Foreign Key Indexes, Graph Queries, Linux Huge Pages, Text Column Size | Scaling Postgres 192
23 Nov 2021
Contributed by Lukas
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 t...
Man-In-The-Middle, pg_auto_failover, Lesser Known Features, LZ4 Compression | Scaling Postgres 191
15 Nov 2021
Contributed by Lukas
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_a...
Hello Babelfish, Planner Deconstruction, Exist & Not Exist, Fun With SQL | Scaling Postgres 190
08 Nov 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the open sourcing of Babelfish, deconstructing the Postgres planner, when to avoid exist & not exi...
Index Downsides, TCP Keep Alive, Development with Postgres, Learning PL/pgSQL | Scaling Postgres 189
01 Nov 2021
Contributed by Lukas
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/...
Automatic Indexing, Function Pipelines, With Hold Cursors, Query Scans | Scaling Postgres 188
25 Oct 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss automatic indexing, function pipelines, with hold cursors and the different query scans. To get the sh...
Sharding, Federation, Linux HugePages, Performance Tuning | Scaling Postgres 187
17 Oct 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss one method to shard a database, federating your database, the benefits of configuring linux HugePages ...
Select For Update, PGx Framework, Cool Additions, Full-Text Search | Scaling Postgres 186
10 Oct 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss select for update, the pgx framework to generate extensions, cool additions to Postgres 14 and full-te...
Postgres 14 Released, Using JSON, Not Using Indexes, Sequence Gaps | Scaling Postgres 185
04 Oct 2021
Contributed by Lukas
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 gap...
Postgres 14 RC1, Little Things, Index Advisor, Million Inserts | Scaling Postgres 184
26 Sep 2021
Contributed by Lukas
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 stat...
Broken Indexes, Trademark Issues, Percentile vs. Average, Logical Improvements | Scaling Postgres 183
20 Sep 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss one cause of broken indexes, Postgres trademark issues, percentiles vs. averages and logical replicati...
Boundless Text, Revoked Permissions, Index Bloat, Hardware Performance | Scaling Postgres 182
12 Sep 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss having boundless text fields, revoking public schema permissions, less index bloat in PG14 and compari...
Connection Scaling, Cached Sequences, Message Queuing, Harmful Subtransactions | Scaling Postgres 181
06 Sep 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss connection scaling, how to cache your sequences, a message queuing implementation and the harms of sub...
Aggregate Filters, Insert-Only & Vacuum, Out-of-sync Sequences, Functional Indexes | Scaling Postgres 180
29 Aug 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how to use aggregate filters, the importance of vacuum with insert-only tables, how to fix out-of-sync...
Foreign Data Wrapper, Timescale Compression, Fuzzy Search, Query Execution | Scaling Postgres 179
23 Aug 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how to use foreign data wrappers, compression available in timescaledb, working with fuzzy search and ...
Postgres Releases, Performance Discussion, Index Types, Index Power Use | Scaling Postgres 178
16 Aug 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss new releases for Postgres & pgbouncer, have a performance discussion, describe the different index...
Planner Workarounds, Grouping Sets, Lateral Join, Not-So-Easy | Scaling Postgres 177
09 Aug 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss ways to work around the planner, working with grouping sets, using a lateral join and not-so-easy Post...
JSONB vs. Window Functions, Security Checklist, Full-Text Search, NFL Time-Series | Scaling Postgres 176
01 Aug 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss JSONB vs. window functions, a Postgres security checklist, implementing full-text search and using NFL...
Zheap Status, Sequence Gaps, Efficient Pagination, Set Up Patroni | Scaling Postgres 175
26 Jul 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the current status of zheap, the gaps in sequences, how to efficiently paginate and how to set up patr...
Lateral Joins, Generating JSON, dbcritic, Fetch First Rows | Scaling Postgres 174
19 Jul 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss understanding lateral joins, generating JSON with Postgres, the dbcritic utility, and fetch first rows...
Delayed Replication, Materialized View Permissons, Paranoid Postgres, Memory Overcommit | Scaling Postgres 173
12 Jul 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how to delay replication, working with materialized view permissions, paranoid configuration options a...
Per-Operation Explain, PG14 Contributions, Foreign Parallel Execution, Incremental View Maintenance | Scaling Postgres 172
04 Jul 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss tracking per-operation explain analyze, Postgres 14 contribution stats, parallel execution on foreign ...
Practical Partitioning, Understanding pg_repack, Explaining Buffers, Multi-row Contraints | Scaling Postgres 171
28 Jun 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss practical partitioning, understanding pg_repack, explaining buffers and enforcing multi-row constraint...
Redis vs Postgres, Hard Quadrant, Optimizing Joins, Materialized Views | Scaling Postgres 170
20 Jun 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss Redis vs. Postgres, working in the hard quadrant, how Postgres optimizes joins and working with materi...
Use Bigint, High Availability, Autocommit, Synchronized Sequential Scans | Scaling Postgres 169
14 Jun 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss only using bigint, high availability, Postgres autocommit and synchronized sequential scans. To get th...
Managing Autovacuum, Better JSON, Avoiding Updates, OS Tuning | Scaling Postgres 168
06 Jun 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss managing autovacuum, better JSON in Postgres 14, how to avoid redundant updates and operating system t...
Interpreting Explain Analyze, Bulk Loading Data, Limiting Update & Delete, pg_buffercache | Scaling Postgres 167
30 May 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how to interpret explain analyze, the best ways to load data in bulk, how to limit rows affected by up...
Postgres 14 Beta 1, PG 14 Improvements, Best Primary Keys, Composite Keys | Scaling Postgres 166
23 May 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the release of Postgres 14 Beta 1, different PG 14 improvements, choosing the best type of primary key...
Postgres Releases, Data Warehouses, Exclusion Operators, Read-Only Users | Scaling Postgres 165
16 May 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the newest Postgres releases, implementing a data warehouse, using exclusion operators and setting up ...
Fast Random Rows, Fast Distinct Queries, Temp & Unlogged Tables, Terminating Connections | Scaling Postgres 164
09 May 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss selecting random rows quickly, faster distinct queries, how replication handles temp and unlogged tabl...
SQL Data Analysis, pgBouncer Setup, Understanding Deadlocks, Tuning & Optimization | Scaling Postgres 163
02 May 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss doing data analysis with SQL, sophisticated pgBouncer set ups, understanding how to avoid deadlocks an...
Custom Data Types, Row Level Triggers, Dynamic pl/pgsql Columns, citext Usage | Scaling Postgres 162
25 Apr 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss implementing row level triggers, how to return dynamic columns using pl/pgsql, and when to use citext....
Scaling Lessons, Synchronous Commit, Connection Management, BLOB Cleanup | Scaling Postgres 161
18 Apr 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss 5 years of scaling lessons, working with synchronous commit, managing connections and cleaning up BLOB...
psql Tips, Postgres 13 Upgrade, Roles Hierarchy, Replica Scaling | Scaling Postgres 160
11 Apr 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss tips for using psql, stories from a Postgres 13 upgrade, exploring the role hierarchy and replica scal...
Tablespaces, Streaming Replication, More Postgres 14, Security | Scaling Postgres 159
04 Apr 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss when to use tablespaces, setting up streaming replication, features coming in Postgres 14 and implemen...
Vacuum Speed Up, Faster Foreign Tables, Fast Queries With Union, Query Optimizer | Scaling Postgres 158
28 Mar 2021
Contributed by Lukas
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 lear...
auto_explain Overhead, Postgres Data Lake, Citus Shard Rebalance, SSL Authentication | Scaling Postgres 157
22 Mar 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss auto_explain's overhead, setting up a Postgres data lake, rebalancing a Citus shared database and impl...
Columnar Storage, Docker Containers, Notify & Listen, Tuning RHEL | Scaling Postgres 156
15 Mar 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss Citus 10 columnar storage, using Postgres in docker containers, using notify & listen for real-tim...
Citus Open Source, Time Series Performance, Subscripting Updates, target_session_attrs | Scaling Postgres 155
08 Mar 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss Citus 10 open source, time series performance in native Postgres, using subscripting for updates and n...
Connection Queuing, Connection Pool Size, Simple Audting, Fuzzy Matching | Scaling Postgres 154
01 Mar 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss connection queuing, estimating connection pools size, how to do simple auditing and how to run queries...
Int to BigInt, Resistance is Futile, Optimizer Statistics, Advanced Query Optimization | Scaling Postgres 153
21 Feb 2021
Contributed by Lukas
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 optimiz...
New Releases, Reconnect After Failure, Bablefish, Troubleshoot Disk & Memory | Scaling Postgres 152
14 Feb 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss new PostgreSQL releases, reconnecting after a connection failure, Babelfish SQL Server compatibility a...
Cleaning Up, Function Performance, 11 Million IOPS, Change Data Capture | Scaling Postgres 151
07 Feb 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss cleaning up your database, function performance, 11 million IOPS and change data capture. To get the s...
Scaling Advice, Vicious Cycle, Improve Observability, Addressing Corruption | Scaling Postgres 150
31 Jan 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss scaling advice, a vicious cycle of WAL writes, how to improve observability and addressing database co...
ARM Tests, Tips & Tricks, Hierarchical Structures, Benchmarking Framework | Scaling Postgres 149
24 Jan 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss tests of Postgres on ARM processors, 2021 tips & tricks, working with hierarchical structures and ...
Hash Indexes, Int Float Numeric Types, Postgres 14 Features, Data Science | Scaling Postgres 148
17 Jan 2021
Contributed by Lukas
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 i...
DBMS of the Year, Better Data Migrations, Idle Connection Impact, Security Implementation Guide | Scaling Postgres 147
10 Jan 2021
Contributed by Lukas
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...
Active-Active & Federated, Memory Speed, Table Rewrite Causes, PostgreSQL Shibboleth | Scaling Postgres 146
04 Jan 2021
Contributed by Lukas
In this episode of Scaling Postgres, we discuss setting up active-active instances with federation, the impact of memory speed, the causes of table re...
PgMiner Botnet, Collation Index Corruption, postgresql.conf, Custom Data Types | Scaling Postgres 145
20 Dec 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the PGMiner botnet attack, how collation changes can cause index corruption, managing your postgresql....
Postgres Migration, Bulk Data Loading, Updates vs. Upgrades, UUID Benchmarks | Scaling Postgres 144
13 Dec 2020
Contributed by Lukas
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 be...
Microsoft SQL Server Compatible, Time Series Performance, Feature Casualties, BLOB Cleanup | Scaling Postgres 143
07 Dec 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss Microsoft SQL server compatibility, the performance of time series DBs, DB feature casualties and how ...
Insert vs. Update, Select * Performance, Debezium Set Up, Standardizing Data | Scaling Postgres 142
29 Nov 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss inserts vs. updates, select * performance, how to set up Debezium and methods to standardize data. To ...
Unattended Upgrade, ARM Benchmarks, Exploration, PostGIS Performance | Scaling Postgres 141
23 Nov 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss an unattended upgrade, ARM Postgres benchmarks, how to explore new databases and PostGIS performance. ...
Replication Conflicts, Postgres Governance, pg_crash, MobilityDB | Scaling Postgres 140
15 Nov 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss replication conflicts, how Postgres is governed, a pg_crash utility and tracking temporal spatial data...
Weekly News, Full-Text Search Performance, pg_cron, Bulk Data Loading | Scaling Postgres 139
08 Nov 2020
Contributed by Lukas
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 l...
Scaling Connections, TimescaleDB, Time-series Gaps, Red & Golden Signals | Scaling Postgres 138
01 Nov 2020
Contributed by Lukas
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 &...
Toast Impact, zheap Storage, More Performance, pg_rewind Changes | Scaling Postgres 137
26 Oct 2020
Contributed by Lukas
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...
Stat Tracking, Temporary Tables, pg_squeeze, pg_auto_failover | Scaling Postgres 136
19 Oct 2020
Contributed by Lukas
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. To...
Connection Scalability, Benchmarking Performance, Community Impact, zheap Progress | Scaling Postgres 135
11 Oct 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss connection scalability, benchmarking Postgres performance, the community impact of an acquisition and ...
Community Acquisition, Space Saving Terabytes, WAL Archiving, Vacuum Analyze Tips | Scaling Postgres 134
04 Oct 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a company acquisition within the Postgres community, how to save terabytes of space, setting up WAL ar...
Postgres 13 Released, What's New In Postgres 13, Debugging PL/PGSQL, Monitoring | Scaling Postgres 133
27 Sep 2020
Contributed by Lukas
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 ...
Postgres 13 RC1, Upgrading at Scale, With Ties, HOT Updates | Scaling Postgres 132
21 Sep 2020
Contributed by Lukas
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 understand...
Slow Archival, Index Improvements, Node Metrics, Join or Subquery | Scaling Postgres 131
13 Sep 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss slow WAL archival, index improvements coming for Postgres 13, accessing node metrics via SQL and decid...
External Compression, Parallel Vacuum, JSON Aggregates, JSON & Arrays | Scaling Postgres 130
06 Sep 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss external compression, vacuuming in parallel, working with JSON Aggregates and the JSON & Array dat...
28 Tips, Lucky 13, Autovacuum Tuning, Logical Pitfalls | Scaling Postgres 129
30 Aug 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss 28 tips & tricks, Postgres 13 is lucky, autovacuum tuning and logical replication pitfalls. To get...
Statistics Speed Up, Synchronous Commits, TLS Updates, Avoiding Cursors | Scaling Postgres 128
24 Aug 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss speeding up performance with statistics, setting synchronous_commit, updates to TLS settings and how t...
Recursive Queries, Lateral Joins, Pagination, JSONB Arrays | Scaling Postgres 127
17 Aug 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss recursive queries, using lateral joins, paging through a data sets efficiently and working with JSONB ...
BRIN Pitfalls, pg_stat_statement Troubleshooting, Natural Join, Geography Type | Scaling Postgres 126
09 Aug 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss BRIN pitfalls, using pg_stat_statements for troubleshooting, natural joins to detect duplicates and th...
Scaling Suggestions, Slot Safety, SCRAM Channel Binding, Effective Cache Size | Scaling Postgres 125
03 Aug 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss suggestions for scaling postgres, replication slots safety, implementing scram password authentication...
Partition Migration, Like Performance, Best Fillfactor, In-Memory Tables | Scaling Postgres 124
27 Jul 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how best to migrate to using partitions, like & ilike performance, determining the best fillfactor...
JSONB Types, Earth Distance, Dates, Times & Intervals, Authentication | Scaling Postgres 123
19 Jul 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss working with JSONB types, calculating earth distance, utilizing dates, times & intervals and Postg...
Postgres is Fine, Generated Columns, Postgres Inserts, Synchronous Replication | Scaling Postgres 122
13 Jul 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss determining if Postgres is fine, generated columns vs. triggers, insert features and synchronous repli...
Fantastic Data Types, Domain Data Types, Insert Performance, Row Differences | Scaling Postgres 121
06 Jul 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss fantastic data types, custom domain data types, improving insert performance and how to query row diff...
Postgres 13 Beta 2, System Stats Extension, Tuned, Join Strategy | Scaling Postgres 120
28 Jun 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss Postgres 13 Beta 2, a system stats extension, tuning your operating systems for Postgres and different...
Replication Complications, One Word Performance, Pgbouncer Users, Serializable Isolation | Scaling Postgres 119
22 Jun 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss replication complications, adding one word to boost performance, handling pgbouncer users and serializ...
Safety Systems, Failover Slots, Transaction ID Complications, Repartitioning | Scaling Postgres 118
14 Jun 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss safety systems, the purpose and existence of failover slots, complications with transaction IDs and ho...
Index Deduplication, Fast Hierarchy, More Monitoring, Cloud-Native | Scaling Postgres 117
08 Jun 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss index deduplication in Postgres 13, fast hierarchical access, more essential monitoring and cloud nati...
Observer Effect, Partition Management, Tuple Freezing, Hung Transactions | Scaling Postgres 116
01 Jun 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the observer effect with explain analyze, partition management, tuple freezing and sources of hung tra...
PGCon Online, Performance Tips, Tracking Counts, Essential Monitoring | Scaling Postgres 115
25 May 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss PGCon going online, application performance tips, ways to track counts and essential areas to monitor....
Data Directory, Vacuum Features, Binary Performance, Network Latency | Scaling Postgres 114
18 May 2020
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the Postgres data directory, new vacuum features, binary storage performance and the impact of network...