Scaling Postgres

By Creston Jamison

Listen to a podcast, please open Podcast Republic app. Available on Google Play Store and Apple App Store.


Category: Technology

Open in Apple Podcasts


Open RSS feed


Open Website


Rate for this podcast
    

Subscribers: 34
Reviews: 1
Episodes: 373

cfchou
 May 12, 2025

Description

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.

Episode Date
Planetscale Postgres! | Scaling Postgres 373
Jul 06, 2025
The Future of Postgres Architecture | Scaling Postgres 372
Jun 29, 2025
Are You Hurting Your Performance? | Scaling Postgres 371
Jun 22, 2025
New Scale Out Options | Scaling Postgres 370
Jun 15, 2025
Move Off Of RDS? | Scaling Postgres 369
Jun 08, 2025
4 Times Faster UUID Primary Keys | Scaling Postgres 368
Jun 01, 2025
How Often Does That Query Run? | Scaling Postgres 367
May 25, 2025
20,000 Times Faster Order By Limit | Scaling Postgres 366
May 18, 2025
Here Comes Async I/O! | Scaling Postgres 365
May 11, 2025
Scaling For High Volume | Scaling Postgres 364
May 04, 2025
Top Ten Postgres Dos & Don'ts | Scaling Postgres 363
Apr 27, 2025
Optimizing For Time-Series Data | Scaling Postgres 362
Apr 20, 2025
A Roadmap To Scaling Postgres | Scaling Postgres 361
Apr 13, 2025
Handle One Million Connections? | Scaling Postgres 360
Apr 06, 2025
Trillions of Rows & Metrics | Scaling Postgres 359
Mar 30, 2025
Postgres Conference 2025 | Scaling Postgres 358
Mar 23, 2025
Postgres Best Practices? | Scaling Postgres 357
Mar 16, 2025
Is the Future Immutable? | Scaling Postgres 356
Mar 09, 2025
Top Ten Analytics with pg_mooncake | Scaling Postgres 355
Mar 02, 2025
Postgres & The US Treasury Attack | Scaling Postgres 354
Feb 23, 2025
OLTP To Parquet For Analytics | Scaling Postgres 353
Feb 16, 2025
You Can Always Optimize More | Scaling Postgres 352
Feb 09, 2025
Features To Avoid? | Scaling Postgres 351
Feb 02, 2025
Seven Years of Scaling Postgres | Scaling Postgres 350
Jan 26, 2025
The Dangers of Temporary Tables | Scaling Postgres 349
Jan 19, 2025
The Future Is Containers? | Scaling Postgres 348
Jan 12, 2025
Easy Incremental Data Processing? | Scaling Postgres 347
Dec 22, 2024
Things I Don't Do In Postgres | Scaling Postgres 346
Dec 15, 2024
Over 5X Faster Postgres? | Scaling Postgres 345
Dec 08, 2024
Performance & Hard Things | Scaling Postgres 344
Dec 01, 2024
Postgres Release Warning! | Scaling Postgres 343
Nov 24, 2024
Faster Writes With ZFS? | Scaling Postgres 342
Nov 17, 2024
The Future of Postgres Upgrades | Scaling Postgres 341
Nov 10, 2024
Do You Need A Vectorizer? | Scaling Postgres 340
Nov 03, 2024
Postgres Goes Parquet | Scaling Postgres 339
Oct 27, 2024
JSON Goodies In Postgres 17 | Scaling Postgres 338
Oct 20, 2024
77 Times Faster In Postgres 17 | Scaling Postgres 337
Oct 13, 2024
More Postgres 17 Highlights | Scaling Postgres 336
Oct 06, 2024
Postgres 17 Released! | Scaling Postgres 335
Sep 29, 2024
Optimizing For Analytics | Scaling Postgres 334
Sep 22, 2024
When Select Writes! | Scaling Postgres 333
Sep 15, 2024
Sometimes It Is Slow? | Scaling Postgres 332
Sep 08, 2024
Is pg_dump A Backup Tool? | Scaling Postgres 331
Sep 01, 2024
Splicing Elephant & Duck DNA | Scaling Postgres 330
Aug 25, 2024
PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329
Aug 18, 2024
Implement Get Or Create | Scaling Postgres 328
Aug 11, 2024
Postgres Graph Queries | Scaling Postgres 327
Aug 04, 2024
Faster Index Creation | Scaling Postgres 326
Jul 28, 2024
Faster Paging? | Scaling Postgres 325
Jul 21, 2024
Four Million TPS | Scaling Postgres 324
Jul 14, 2024
PgBouncer Breaking Change | Scaling Postgres 323
Jul 07, 2024
Postgres Sort Instability? | Scaling Postgres 322
Jun 30, 2024
Ottertune Is Dead! | Scaling Postgres 321
Jun 23, 2024
100 TB and Beyond! | Scaling Postgres 320
Jun 16, 2024
When Postgres Development Stopped! | Scaling Postgres 319
Jun 09, 2024
Postgres 17 Beta 1 Released | Scaling Postgres 318
Jun 02, 2024
Time-Series Open Source Extension | Scaling Postgres 317
May 26, 2024
New Releases & 1,000 Times Faster Query | Scaling Postgres 316
May 19, 2024
Hacking On Postgres is Hard! | Scaling Postgres 315
May 12, 2024
150 Times Faster pgvector? | Scaling Postgres 314
May 05, 2024
The Future of MySQL is Postgres? | Scaling Postgres 313
Apr 28, 2024
Postgres 17 Commit-orama | Scaling Postgres 312
Apr 21, 2024
1,400 Times Faster Max & Group By Performance | Scaling Postgres 311
Apr 14, 2024
Andres, Microsoft & Postgres Save Linux? | Scaling Postgres 310
Apr 07, 2024
Will Postgres Pull A Redis? | Scaling Postgres 309
Mar 31, 2024
Scale Through Sharding | Scaling Postgres 308
Mar 24, 2024
Collation Conundrum | Scaling Postgres 307
Mar 17, 2024
Scalability Limits From SLRU & Lock Manager | Scaling Postgres 306
Mar 10, 2024
11K Faster Configuration Change | Scaling Postgres 305
Mar 03, 2024
Overhead of pg_stat_statements | Scaling Postgres 304
Feb 25, 2024
PgBouncer, PgCat, Supavisor Fight!!! | Scaling Postgres 303
Feb 18, 2024
UUID vs Bigint Battle!!! | Scaling Postgres 302
Feb 11, 2024
Postgres LLM OS & 30 Times Faster Index Builds | Scaling Postgres 301
Feb 04, 2024
Scaling Postgres Celebration | Scaling Postgres 300
Jan 28, 2024
Build A GPT In SQL | Scaling Postgres 299
Jan 21, 2024
10-100 Times Higher Latency With Distributed Postgres | Scaling Postgres 298
Jan 14, 2024
Postgres In 2024 | Scaling Postgres 297
Jan 07, 2024
State Of Postgres 2023 | Scaling Postgres 296
Dec 24, 2023
30K Messages Per Second Queue | Scaling Postgres 295
Dec 17, 2023
How Much Observability Is Needed? | Scaling Postgres 294
Dec 11, 2023
Better Plans With Statistics | Scaling Postgres 293
Dec 04, 2023
Companion Databases? | Scaling Postgres 292
Nov 26, 2023
2 To 4 Times Faster With Vectorization | Scaling Postgres 291
Nov 19, 2023
Postgres Releases = Reindexing | Scaling Postgres 290
Nov 12, 2023
Postgres Scheduling Opportunities | Scaling Postgres 289
Nov 05, 2023
Index Corruption From ICU Collation Change | Scaling Postgres 288
Oct 29, 2023
15% - 250% Faster Query Throughput | Scaling Postgres 287
Oct 22, 2023
20 Times Faster Text Search & Ranking? | Scaling Postgres 286
Oct 15, 2023
Indexing Deep Dive | Scaling Postgres 285
Oct 08, 2023
23 Or 1.1 Times Faster Performance? | Scaling Postgres 284
Oct 01, 2023
222 Times Faster Analytical Queries With Columnar Storage | Scaling Postgres 283
Sep 24, 2023
Postgres 16 Released, The Postgres Meme, File vs base64 Strings, Intelligent Sharding | Scaling Postgres 282
Sep 17, 2023
HNSW Indexes, Vacuuming Bloat, Watch Me Now, Connections | Scaling Postgres 281
Sep 10, 2023
Postgres 16 RC1, Bi-Directional Replication, All About Parameters, Foreign Keys & Polymorphism | Scaling Postgres 280
Sep 03, 2023
TPS Benchmark, Partition-wise Join & Aggregate, Partitioning Billions, Posgres 16 Features | Scaling Postgres 279
Aug 27, 2023
Squeeze Your System, One Million Connections, Indexing LIKE, pgvector HNSW | Scaling Postgres 278
Aug 20, 2023
Postgres Releases, PostgreSQL Survey, Partitioning vs. Sharding, Bulk Loading | Scaling Postgres 277
Aug 13, 2023
BRIN & Correlation, Poor Partitioning, 10 Beginner Tips, Table & Index Usage | Scaling Postgres 276
Jul 30, 2023
No More Vacuum, Zero-Downtime Cut-Over, Network Impact, Not In Optimization | Scaling Postgres 275
Jul 23, 2023
Subquery Performance, Avoid Update Locking, Column Changes, Outage Workshop | Scaling Postgres 274
Jul 16, 2023
Debian / Ubuntu Packaging, ivfflat Indexes, In vs Any, View Logging | Scaling Postgres 273
Jul 10, 2023
Postgres 16 Beta 2, The Rise of Vectors, FDW Performance, Unused Indexes | Scaling Postgres 272
Jul 03, 2023
30% Faster, UUID Downsides, Growing WAL, Processes vs. Threads | Scaling Postgres 271
Jun 26, 2023
Data Skew, Monitoring, Remote Access CSV, Documentation | Scaling Postgres 270
Jun 18, 2023
Upgrade Struggles, Hyperloglog, PgBouncer Usage, Postgres Scaling | Scaling Postgres 269
Jun 11, 2023
Faster Copy, psql Variables, backup_label, Bad Encoding | Scaling Postgres 268
Jun 04, 2023
PostgreSQL 16 Beta 1, Rust Functions, Partitioning Memory Problems, Tags & Arrays | Scaling Postgres 267
May 28, 2023
Postgres Releases, Postgres Distributed, Privilege Template, Real-Time Dashboards | Scaling Postgres 266
May 21, 2023
pg_stat_statements, Transaction ID Wraparound, Consultant Knowledge, CitusCon | Scaling Postgres 265
May 14, 2023
The Worst Part, Pluggable Storage, A Busy System, Data Architecture | Scaling Postgres 264
May 07, 2023
LZ4 & ZSTD Compression, Avoiding Problems, Triggers Simplify, Indexes Can Hurt | Scaling Postgres 263
May 01, 2023
pg_failover_slots, Standby Logical Decoding, Trusted Language Extensions, Postgres Package Manager | Scaling Postgres 262
Apr 23, 2023
Easy Foreign Data Wrappers, JSONB Cheatsheet, Updating Cost Limit, Parallel Aggregate | Scaling Postgres 261
Apr 17, 2023
PL/Rust, Row Locks, Postgres Errors, SQL 2023 | Scaling Postgres 260
Apr 09, 2023
Recovery Time, Lost Data, Production Ready, PG16 Highlights | Scaling Postgres 259
Apr 02, 2023
Logical Replication, Database Antipatterns, max_wal_size Setting, Delete vs. Truncate | Scaling Postgres 258
Mar 27, 2023
Adopting PgCat, Time Bins, work_mem Settings, Bad Constraints | Scaling Postgres 257
Mar 19, 2023
11TB WAL, pgec Writes, Patroni 3 & Citus, PostgREST | Scaling Postgres 256
Mar 12, 2023
Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255
Mar 05, 2023
PG Edge Cache, Postgres & OpenAI, citext to Collations, Compression Options | Scaling Postgres 254
Feb 26, 2023
Unlogged Tables, pg_stat_io, Type Constraints, Text Types | Scaling Postgres 253
Feb 19, 2023
Postgres Releases, Performance Secrets, Don't Do This, Filter vs. Case | Scaling Postgres 252
Feb 12, 2023
Filter Clause, Hypothetical Index, Non-Relational Data, Using TOAST | Scaling Postgres 251
Feb 05, 2023
Performance Issue, Survive Without Superuser, Reserved Connections, Partition Management | Scaling Postgres 250
Jan 30, 2023
Locking Tables, Foreign Key Issue, Slow Decimals, Memoize & Joins | Scaling Postgres 249
Jan 23, 2023
Pagination Solutions, Return Modifications, Insert Deletions, How To JSON | Scaling Postgres 248
Jan 15, 2023
Generate Test Data, Faster Archiving, Date Statistics, Useless Indexes | Scaling Postgres 247
Jan 11, 2023
Columnar Tables, Advent of Code, PG 16 Features, Commit Times | Scaling Postgres 246
Dec 18, 2022
ENUMs vs Check Constraints, Faceting With Roaring Bitmaps, Better Scaling, In DB Business Logic | Scaling Postgres 245
Dec 12, 2022
Index Merge vs Composite, Transparent Column Encryption, Trusted Language Extensions | Scaling Postgres 244
Dec 04, 2022
IN vs ANY, Ghost Conditions, Percentage Calculations, Variadic Unnest | Scaling Postgres 243
Nov 27, 2022
Reduce Replication Lag, Explain Parameterized Query, PostGIS Day, Multiple PgBouncers | Scaling Postgres 242
Nov 21, 2022
Postgres 15.1, Postres 10 Retrospective, Reducing Replication Lag, Listen & Notify | Scaling Postgres 241
Nov 13, 2022
Forced Sequential Scans, Table Renaming, Terminology, PGSQL Phriday | Scaling Postgres 240
Nov 06, 2022
Shared Buffers, Compression Algorithm, Merge Command, Postgres Contributions | Scaling Postgres 239
Oct 30, 2022
Slow Updates, Lateral Joins, Serial To Identity, PG 15 Changes | Scaling Postgres 238
Oct 24, 2022
Postgres 15 Released, File Systems, Connection Pooling, Secure Connections | Scaling Postgres 237
Oct 16, 2022
Postgres 15 RC2, Shared Buffers, Secure Connections, PGSQL Phriday | Scaling Postgres 236
Oct 10, 2022
Postgres 15 RC1, ICU Collations, Listen & Notify, Understanding TOAST | Scaling Postgres 235
Oct 03, 2022
Rust for Extensions, Timescale vs. Postgres, Uninterrupted Sharding, Data Flow | Scaling Postgres 234
Sep 25, 2022
Useful Features, Community Blogging, PG 15 Anticipation, Generic Plans | Scaling Postgres 233
Sep 18, 2022
PG15 Beta 4, Primary Key Options, Sequence Limits, Configuration | Scaling Postgres 232
Sep 12, 2022
PG15 Public Schema, Kubernetes Experiences, Dump Manifests, PgBouncer Fork | Scaling Postgres 231
Sep 04, 2022
Stats Collector Gone, Handling Latency, PG In The Browser, Future High Availability | Scaling Postgres 230
Aug 28, 2022
Postgres Playground, PG14 Internals, DB Corruption, Anti-Join | Scaling Postgres 229
Aug 22, 2022
New Postgres Releases, Privilege Escalation CVE, Chaos Testing, High Availability | Scaling Postgres 228
Aug 14, 2022
Researching Performance, Postgres Survey, pgAdmin Survey, Long Running Queries | Scaling Postgres 227
Aug 07, 2022
SQL Functions, Explain Analyze Buffers, Debug Autovacuum, RLS Multi-Tenancy | Scaling Postgres 226
Jul 31, 2022
PSQL GEXEC, Delete Duplicates, Postgres Podcast, Puny to Powerful | Scaling Postgres 225
Jul 24, 2022
Column Performance, BRIN Win, Unique and Null, Parallel Distinct | Scaling Postgres 224
Jul 18, 2022
Database Decomposition, Fast Text Search, Understanding pg_stat_activity, Window Functions | Scaling Postgres 223
Jul 10, 2022
Postgres 15 Beta 2, Concerning Locks, Vacuum Tuning, Transaction Anomalies | Scaling Postgres 222
Jul 04, 2022
psql Shortcuts, Debugging Deadlocks, Find & Stop Queries, Using SCRAM | Scaling Postgres 221
Jun 27, 2022
PG 14.4 Release, Subscription Skip, Using Schemas, Open Source Citus | Scaling Postgres 220
Jun 19, 2022
Out-Of-Cycle Release, Should You Upgrade, Postgres Survey, Automatic Indexing | Scaling Postgres 219
Jun 13, 2022
PG14 Index Bug, View Permissions, Logical Replication Conflicts, AlloyDB Under the Hood | Scaling Postgres 218
Jun 05, 2022
Schema Change Mistakes, Canceling Statements, pg_rman, Pedantry Removal | Scaling Postgres 217
May 29, 2022
PG 15 Beta 1 Release, Query Breakdown, Sort Performance, Prepared vs. Partitioned | Scaling Postgres 216
May 22, 2022
New Releases, AlloyDB, Time Zones, Connecting to Postgres | Scaling Postgres 215
May 15, 2022
Backup Compression, Postgres IO, Parquet Files, pg_stat_monitor | Scaling Postgres 214
May 08, 2022
Planner Optimization, Fish to Elephants, Large Databases, Spatial Data | Scaling Postgres 213
May 01, 2022
Slow Queries, 4TB Upgrade, Postgres on ZFS, Storage Stampede | Scaling Postgres 212
Apr 24, 2022
Multiranges, Missing Metrics, Newbie PostGIS, Conference Videos | Scaling Postgres 211
Apr 17, 2022
Date Time Bins, Search Every Field, JSON_TABLE, Picking Primary | Scaling Postgres 210
Apr 10, 2022
Tidy Vacuum, Dropping Roles, Merge Command, PgBouncer Tutorial | Scaling Postgres 209
Apr 03, 2022
pgbouncer Released, Query Parameter Types, Lateral Joins, Security Invoker Views | Scaling Postgres 208
Mar 27, 2022
Autovacuum Configuration, Duplicate Key Violations, Pipelining, Tuning max_wal_size | Scaling Postgres 207
Mar 20, 2022
100x Optimizations, Auditing, Document Schema Designs, Checksums | Scaling Postgres 206
Mar 13, 2022
Indexing With tsearch, Tuples Not Yet Removable, Wicked Problems, Pattern Matching | Scaling Postgres 205
Mar 07, 2022
Optimizing Trigram Search, Replication Review, Logical Improvements, Timescale Investment | Scaling Postgres 204
Feb 27, 2022
Saving Space, Working with TOAST, Protecting Data, High CPU Utilization | Scaling Postgres 203
Feb 20, 2022
New Postgres Releases, A Hairy Incident, Slow Down To Go Faster, Loadable Module Archiving | Scaling Postgres 202
Feb 14, 2022
JSONB Performance, Bidirectional Replication, Most Recent Record, PG14 JSON | Scaling Postgres 201
Feb 07, 2022
5 Minutes of Postgres, Unnest, SCRAM, Multi-master Review | Scaling Postgres 200
Jan 30, 2022
Shaped Sample Data, Version Changes, Missed Bottlenecks, Indexes for Newbies | Scaling Postgres 199
Jan 24, 2022
Monitoring Progress, More SQL, Replication Slot Failover, Postgres Contributors | Scaling Postgres 198
Jan 16, 2022
Explain Analyze Buffers, Healthier Postgres, 2021 Review, High Availability Aspirations | Scaling Postgres 197
Jan 09, 2022
Easy Recursive CTE, Zheap Undo, High Availability, Loading Data | Scaling Postgres 196
Dec 19, 2021
Aurora vs. Postgres, Surprising Transactions, Write-Only & Read-Only, Indexing Advice | Scaling Postgres 195
Dec 13, 2021
Go Faster, GIN Indexes, Collation Stability, PG14 & Beyond | Scaling Postgres 194
Dec 10, 2021
Entity-Attribute-Value Design, JSON Subscripting, mysql-fdw Push-down, New Regex | Scaling Postgres 193
Nov 28, 2021
Foreign Key Indexes, Graph Queries, Linux Huge Pages, Text Column Size | Scaling Postgres 192
Nov 23, 2021
Man-In-The-Middle, pg_auto_failover, Lesser Known Features, LZ4 Compression | Scaling Postgres 191
Nov 15, 2021
Hello Babelfish, Planner Deconstruction, Exist & Not Exist, Fun With SQL | Scaling Postgres 190
Nov 08, 2021
Index Downsides, TCP Keep Alive, Development with Postgres, Learning PL/pgSQL | Scaling Postgres 189
Nov 01, 2021
Automatic Indexing, Function Pipelines, With Hold Cursors, Query Scans | Scaling Postgres 188
Oct 25, 2021
Sharding, Federation, Linux HugePages, Performance Tuning | Scaling Postgres 187
Oct 17, 2021
Select For Update, PGx Framework, Cool Additions, Full-Text Search | Scaling Postgres 186
Oct 10, 2021
Postgres 14 Released, Using JSON, Not Using Indexes, Sequence Gaps | Scaling Postgres 185
Oct 04, 2021
Postgres 14 RC1, Little Things, Index Advisor, Million Inserts | Scaling Postgres 184
Sep 26, 2021
Broken Indexes, Trademark Issues, Percentile vs. Average, Logical Improvements | Scaling Postgres 183
Sep 20, 2021
Boundless Text, Revoked Permissions, Index Bloat, Hardware Performance | Scaling Postgres 182
Sep 12, 2021
Connection Scaling, Cached Sequences, Message Queuing, Harmful Subtransactions | Scaling Postgres 181
Sep 06, 2021
Aggregate Filters, Insert-Only & Vacuum, Out-of-sync Sequences, Functional Indexes | Scaling Postgres 180
Aug 29, 2021
Foreign Data Wrapper, Timescale Compression, Fuzzy Search, Query Execution | Scaling Postgres 179
Aug 23, 2021
Postgres Releases, Performance Discussion, Index Types, Index Power Use | Scaling Postgres 178
Aug 16, 2021
Planner Workarounds, Grouping Sets, Lateral Join, Not-So-Easy | Scaling Postgres 177
Aug 09, 2021
JSONB vs. Window Functions, Security Checklist, Full-Text Search, NFL Time-Series | Scaling Postgres 176
Aug 01, 2021
Zheap Status, Sequence Gaps, Efficient Pagination, Set Up Patroni | Scaling Postgres 175
Jul 26, 2021
Lateral Joins, Generating JSON, dbcritic, Fetch First Rows | Scaling Postgres 174
Jul 19, 2021
Delayed Replication, Materialized View Permissons, Paranoid Postgres, Memory Overcommit | Scaling Postgres 173
Jul 12, 2021
Per-Operation Explain, PG14 Contributions, Foreign Parallel Execution, Incremental View Maintenance | Scaling Postgres 172
Jul 04, 2021
Practical Partitioning, Understanding pg_repack, Explaining Buffers, Multi-row Contraints | Scaling Postgres 171
Jun 28, 2021
Redis vs Postgres, Hard Quadrant, Optimizing Joins, Materialized Views | Scaling Postgres 170
Jun 20, 2021
Use Bigint, High Availability, Autocommit, Synchronized Sequential Scans | Scaling Postgres 169
Jun 14, 2021
Managing Autovacuum, Better JSON, Avoiding Updates, OS Tuning | Scaling Postgres 168
Jun 06, 2021
Interpreting Explain Analyze, Bulk Loading Data, Limiting Update & Delete, pg_buffercache | Scaling Postgres 167
May 30, 2021
Postgres 14 Beta 1, PG 14 Improvements, Best Primary Keys, Composite Keys | Scaling Postgres 166
May 23, 2021
Postgres Releases, Data Warehouses, Exclusion Operators, Read-Only Users | Scaling Postgres 165
May 16, 2021
Fast Random Rows, Fast Distinct Queries, Temp & Unlogged Tables, Terminating Connections | Scaling Postgres 164
May 09, 2021
SQL Data Analysis, pgBouncer Setup, Understanding Deadlocks, Tuning & Optimization | Scaling Postgres 163
May 02, 2021
Custom Data Types, Row Level Triggers, Dynamic pl/pgsql Columns, citext Usage | Scaling Postgres 162
Apr 25, 2021
Scaling Lessons, Synchronous Commit, Connection Management, BLOB Cleanup | Scaling Postgres 161
Apr 18, 2021
psql Tips, Postgres 13 Upgrade, Roles Hierarchy, Replica Scaling | Scaling Postgres 160
Apr 11, 2021
Tablespaces, Streaming Replication, More Postgres 14, Security | Scaling Postgres 159
Apr 04, 2021
Vacuum Speed Up, Faster Foreign Tables, Fast Queries With Union, Query Optimizer | Scaling Postgres 158
Mar 28, 2021
auto_explain Overhead, Postgres Data Lake, Citus Shard Rebalance, SSL Authentication | Scaling Postgres 157
Mar 22, 2021
Columnar Storage, Docker Containers, Notify & Listen, Tuning RHEL | Scaling Postgres 156
Mar 15, 2021
Citus Open Source, Time Series Performance, Subscripting Updates, target_session_attrs | Scaling Postgres 155
Mar 08, 2021
Connection Queuing, Connection Pool Size, Simple Audting, Fuzzy Matching | Scaling Postgres 154
Mar 01, 2021
Int to BigInt, Resistance is Futile, Optimizer Statistics, Advanced Query Optimization | Scaling Postgres 153
Feb 21, 2021
New Releases, Reconnect After Failure, Bablefish, Troubleshoot Disk & Memory | Scaling Postgres 152
Feb 14, 2021
Cleaning Up, Function Performance, 11 Million IOPS, Change Data Capture | Scaling Postgres 151
Feb 07, 2021
Scaling Advice, Vicious Cycle, Improve Observability, Addressing Corruption | Scaling Postgres 150
Jan 31, 2021
ARM Tests, Tips & Tricks, Hierarchical Structures, Benchmarking Framework | Scaling Postgres 149
Jan 24, 2021
Hash Indexes, Int Float Numeric Types, Postgres 14 Features, Data Science | Scaling Postgres 148
Jan 17, 2021
DBMS of the Year, Better Data Migrations, Idle Connection Impact, Security Implementation Guide | Scaling Postgres 147
Jan 10, 2021
Active-Active & Federated, Memory Speed, Table Rewrite Causes, PostgreSQL Shibboleth | Scaling Postgres 146
Jan 04, 2021
PgMiner Botnet, Collation Index Corruption, postgresql.conf, Custom Data Types | Scaling Postgres 145
Dec 20, 2020
Postgres Migration, Bulk Data Loading, Updates vs. Upgrades, UUID Benchmarks | Scaling Postgres 144
Dec 13, 2020
Microsoft SQL Server Compatible, Time Series Performance, Feature Casualties, BLOB Cleanup | Scaling Postgres 143
Dec 07, 2020
Insert vs. Update, Select * Performance, Debezium Set Up, Standardizing Data | Scaling Postgres 142
Nov 29, 2020
Unattended Upgrade, ARM Benchmarks, Exploration, PostGIS Performance | Scaling Postgres 141
Nov 23, 2020
Replication Conflicts, Postgres Governance, pg_crash, MobilityDB | Scaling Postgres 140
Nov 15, 2020
Weekly News, Full-Text Search Performance, pg_cron, Bulk Data Loading | Scaling Postgres 139
Nov 08, 2020
Scaling Connections, TimescaleDB, Time-series Gaps, Red & Golden Signals | Scaling Postgres 138
Nov 01, 2020
Toast Impact, zheap Storage, More Performance, pg_rewind Changes | Scaling Postgres 137
Oct 26, 2020
Stat Tracking, Temporary Tables, pg_squeeze, pg_auto_failover | Scaling Postgres 136
Oct 19, 2020
Connection Scalability, Benchmarking Performance, Community Impact, zheap Progress | Scaling Postgres 135
Oct 11, 2020
Community Acquisition, Space Saving Terabytes, WAL Archiving, Vacuum Analyze Tips | Scaling Postgres 134
Oct 04, 2020
Postgres 13 Released, What's New In Postgres 13, Debugging PL/PGSQL, Monitoring | Scaling Postgres 133
Sep 27, 2020
Postgres 13 RC1, Upgrading at Scale, With Ties, HOT Updates | Scaling Postgres 132
Sep 21, 2020
Slow Archival, Index Improvements, Node Metrics, Join or Subquery | Scaling Postgres 131
Sep 13, 2020
External Compression, Parallel Vacuum, JSON Aggregates, JSON & Arrays | Scaling Postgres 130
Sep 06, 2020
28 Tips, Lucky 13, Autovacuum Tuning, Logical Pitfalls | Scaling Postgres 129
Aug 30, 2020
Statistics Speed Up, Synchronous Commits, TLS Updates, Avoiding Cursors | Scaling Postgres 128
Aug 24, 2020
Recursive Queries, Lateral Joins, Pagination, JSONB Arrays | Scaling Postgres 127
Aug 17, 2020
BRIN Pitfalls, pg_stat_statement Troubleshooting, Natural Join, Geography Type | Scaling Postgres 126
Aug 09, 2020
Scaling Suggestions, Slot Safety, SCRAM Channel Binding, Effective Cache Size | Scaling Postgres 125
Aug 03, 2020
Partition Migration, Like Performance, Best Fillfactor, In-Memory Tables | Scaling Postgres 124
Jul 27, 2020
JSONB Types, Earth Distance, Dates, Times & Intervals, Authentication | Scaling Postgres 123
Jul 19, 2020
Postgres is Fine, Generated Columns, Postgres Inserts, Synchronous Replication | Scaling Postgres 122
Jul 13, 2020
Fantastic Data Types, Domain Data Types, Insert Performance, Row Differences | Scaling Postgres 121
Jul 06, 2020
Postgres 13 Beta 2, System Stats Extension, Tuned, Join Strategy | Scaling Postgres 120
Jun 28, 2020
Replication Complications, One Word Performance, Pgbouncer Users, Serializable Isolation | Scaling Postgres 119
Jun 22, 2020
Safety Systems, Failover Slots, Transaction ID Complications, Repartitioning | Scaling Postgres 118
Jun 14, 2020
Index Deduplication, Fast Hierarchy, More Monitoring, Cloud-Native | Scaling Postgres 117
Jun 08, 2020
Observer Effect, Partition Management, Tuple Freezing, Hung Transactions | Scaling Postgres 116
Jun 01, 2020
PGCon Online, Performance Tips, Tracking Counts, Essential Monitoring | Scaling Postgres 115
May 25, 2020
Data Directory, Vacuum Features, Binary Performance, Network Latency | Scaling Postgres 114
May 18, 2020
arm64 with apt, Contributors, Backup Manifest, Now Functions | Scaling Postgres 113
May 11, 2020
Explain Analyze, Sequence Counts, Best Books, Partition Migration | Scaling Postgres 112
May 04, 2020
Insert-Only Vacuum, Settings, Sequence Replication, Improvements | Scaling Postgres 111
Apr 26, 2020
Max Connections, SQL Tricks, Fast Text Search, Security & Compliance | Scaling Postgres 110
Apr 20, 2020
Show Plans, WAL Monitoring, Using UUIDs, Default Logging | Scaling Postgres 109
Apr 13, 2020
Ten Things, Audit Triggers, Schema Design, High Availability | Scaling Postgres 108
Apr 06, 2020
Showing Plans, Atomic, Configuration, Migrations | Scaling Postgres 107
Mar 30, 2020
Recursive CTEs, DB Access Patterns, Dates & Times, Cluster | Scaling Postgres 106
Mar 23, 2020
World's Best, Subtransactions, Sharding, Schema Changes | Scaling Postgres 105
Mar 16, 2020
Reducing WAL, What is Null?, Understanding SQL, TPC-H Benchmarking | Scaling Postgres 104
Mar 09, 2020
Scaling Out, Planner Estimation, Create Statistics, Stay Curious | Scaling Postgres 103
Mar 02, 2020
UUID Use Cases, pg_settings, Automated Restore, Parallel Future | Scaling Postgres 102
Feb 24, 2020
Postgres Releases, Useless Vacuum, Isolation Differences, WAL Compression | Scaling Postgres 101
Feb 17, 2020
Full Text Search, Query Optimization, Exception Blocks, Procedural Language | Scaling Postgres 100
Feb 10, 2020
Ballad of Bloat, Auditing Options, Configuration Options, Need Vacuum? | Scaling Postgres 99
Feb 03, 2020
Non-Relational Data, Contributers, Security Features, High Availability | Scaling Postgres 98
Jan 26, 2020
Tips & Tricks, Faster APIs, Full Text Search, pgbouncer_fdw | Scaling Postgres 97
Jan 20, 2020
Account Configuration, Pricing, System Identifier, HyperLogLog | Scaling Postgres 96
Jan 13, 2020
max_locks_per_transaction, Logical Replication, Backup & Recovery, Pgbouncer | Scaling Postgres 95
Jan 06, 2020
State of Postgres, Dumping DBs, Configuration Parameters, Partial WAL | Scaling Postgres 94
Dec 16, 2019
Logical Replication, Monitoring Queries, SQL Beautifier, Incomplete Startup Packet | Scaling Postgres 93
Dec 09, 2019
Book Sales, B-tree Boost, More Postgres 12, Using pgBackRest | Scaling Postgres 92
Dec 02, 2019
Global Indexes, Caching Aggregates, Vacuum Processing, Effective Cache Size | Scaling Postgres 91
Nov 25, 2019
Chaos Order, Pub Sub, Petabyte Scale, PgBouncer Connections | Scaling Postgres 90
Nov 18, 2019
Performance Impressions, Mystery Solving, GiST Performance, K-Anonymity | Scaling Postgres 89
Nov 11, 2019
Partitioning, Logical Replication Upgrade, Columnar Compression, HAProxy Connections | Scaling Postgres 88
Nov 04, 2019
pg_receivewal, Application Failover, pg_checksums, pgBouncer | Scaling Postgres 87
Oct 28, 2019
Prewarming, Nondeterministic Collations, Generated Column Performance, Foreign Keys | Scaling Postgres 86
Oct 20, 2019
Recovery Configuration, Alter System, Transaction Isolation, Temp Table Vacuum | Scaling Postgres 85
Oct 14, 2019
Postgres 12 Released, Generated Columns, Parallel Estimates, Change Data Capture | Scaling Postgres 84
Oct 07, 2019
Postgres 12, Window Frames, Index Types, Synchronous Replication | Scaling Postgres 83
Sep 30, 2019
Faster Partitions, Count Speed, Extensions, Education | Scaling Postgres 82
Sep 23, 2019
Data Loading Speed, View Dependencies, Users & Roles, H/A Clusters | Scaling Postgres 81
Sep 16, 2019
Just Upgrade, Vacuum Updates, Connection Strings, Postgres Showcase | Scaling Postgres 80
Sep 09, 2019
PgBouncer SCRAM, Art of PostgreSQL, Distributed Time-Series, Window Functions | Scaling Postgres 79
Sep 02, 2019
Efficient Pagination, Rotating Passwords, BRIN, Row Level Security | Scaling Postgres 78
Aug 25, 2019
Timeseries Queries, Arrays, Ranges, C Triggers | Scaling Postgres 77
Aug 19, 2019
New CVEs, Postgres Programming, JSONB, Advisory Locks | Scaling Postgres 76
Aug 12, 2019
Combining Indexes, Regular Expressions, Parallelism, PostGIS | Scaling Postgres 75
Aug 05, 2019
Picturing Vacuum, Recovery Changes, Cert Authentication, Function Replication | Scaling Postgres 74
Jul 29, 2019
BRIN Indexes, Partition Enhancements, Tips, Standbys | Scaling Postgres 73
Jul 22, 2019
Collation Issues, Fast Loading, Recovery, SCRAM Authentication | Scaling Postgres 72
Jul 15, 2019
Indexing Documents, GIN Indexes, Data Science, Generated Columns | Scaling Postgres 71
Jul 08, 2019
Default Security, Max Connections, Progress Reporting, Migration | Scaling Postgres 70
Jul 01, 2019
Performance Training, JSON Path, Hypothetical Indexes, Interpolation | Scaling Postgres 69
Jun 24, 2019
Prepared Plans, Materialization, Recursive CTEs, Safe Migrations | Scaling Postgres 68
Jun 16, 2019
PGCon, Tips, PostGIS, Strings | Scaling Postgres 67
Jun 09, 2019
Query Optimization, Normalization, Visualizing Vacuum, Sharding | Scaling Postgres 66
Jun 03, 2019
Multi Column, Multi DB, Dos & Don'ts, RUM Indexes | Scaling Postgres 65
May 26, 2019
Leveraging Indexes, Slugs, Addresses, Security Definer | Scaling Postgres 64
May 20, 2019
Slow Queries, pg_auto_failover, Roles, Hyperscale | Scaling Postgres 63
May 12, 2019
Index Include Clause, Exporting CSV, JSON, Zedstore | Scaling Postgres 62
May 05, 2019
Constraint Triggers, Simple Shards, Data Streams, OIDs | Scaling Postgres 61
Apr 29, 2019
Pluggable Storage, Developer Gotchas, Cursors, PG12 | Scaling Postgres 60
Apr 21, 2019
Popularity, Load Testing, Checksums, pg_hba | Scaling Postgres 59
Apr 14, 2019
Security Concerns, Fast Counting, Indexing, Trends | Scaling Postgres 58
Apr 08, 2019
Checking Vacuum, Fast Distinct Count, Group By Speed Up, Health Check | Scaling Postgres 57
Mar 31, 2019
Practical Indexing, Vertical Scaling, Partition Migration, FDW Performance | Scaling Postgres 56
Mar 24, 2019
Replicating Data, SQL Functions, High Availability, Locking Issues | Scaling Postgres 55
Mar 18, 2019
Index-Only Scans, Lock Table, Hot Standby Feedback, Large Backups | Scaling Postgres 54
Mar 11, 2019
Query Planner, BRIN Indexes, Approximate Algorithms, Delayed Replication | Scaling Postgres 53
Mar 04, 2019
fsync Stopgap, CTE Changes, autovacuum_naptime, Postgres Community | Scaling Postgres 52
Feb 25, 2019
Value of SQL, Window Functions, DB Migrations, Data Storage | Scaling Postgres 51
Feb 18, 2019
Outage from TXIDs, Breaking Scale, fsync Gate, pg_stat_statements | Scaling Postgres 50
Feb 11, 2019
Over One Billion, No Downtime, SQL Life, Throughput | Scaling Postgres 49
Feb 04, 2019
Microsoft Acquires Citus Data, Split WAL, Maintenance Work Mem | Scaling Postgres 48
Jan 27, 2019
pgBouncer, Postgres 11 Gems, DocumentDB, JSON | Scaling Postgres 47
Jan 20, 2019
Stuck Transaction IDs, pgBouncer Auth, UUIDs, Monitoring | Scaling Postgres 46
Jan 13, 2019
DBMS of 2018, Data Anonymization, JIT, Reserved Keywords | Scaling Postgres 45
Jan 07, 2019
Postgres Rise, Row Count Estimates, Nulls, Linux Config | Scaling Postgres 44
Dec 31, 2018
Logical Replication, Prepared Transactions, Ansible, Partitions | Scaling Postgres 43
Dec 17, 2018
Multi-Terabyte Scaling, Kubernetes DBaaS, Encryption, High Availability | Scaling Postgres 42
Dec 09, 2018
Sequential UUIDs, Runnning Totals, Read Committed, TOAST | Scaling Postgres 41
Dec 03, 2018
Materialized, PgBouncer Auth, Implicit vs Explicit, JIT | Scaling Postgres 40
Nov 25, 2018
Bloat vs zHeap, Composite Indexes, Unsafe Operations | Scaling Postgres 39
Nov 19, 2018
Parallel Query, Real Time Analytics, Killed Index Tuples | Scaling Postgres 38
Nov 12, 2018
Postgres Goodies, Materialized vs Rollup, Column Oriented | Scaling Postgres 37
Nov 05, 2018
Sharding, Giving Back, SCRAM, Partitioning Evolution | Scaling Postgres 36
Oct 29, 2018
Terabyte Scaling, Postgres 11, Connections, Backup | Scaling Postgres 35
Oct 22, 2018
Inserts, Nearest Neighbor, Freezing, Comment | Scaling Postgres 34
Oct 15, 2018
Per-Table Autovacuum, FDW Synchronization, Distinct On | Scaling Postgres 33
Oct 08, 2018
Sysadmin Concerns, Power of Indexing, pgbouncer Monitoring | Scaling Postgres 32
Oct 01, 2018
CTE Warning, PG 11 Features, Death by DB, Correlation | Scaling Postgres 31
Sep 24, 2018
Parallelism, JIT Compiling, Indexes, Administration | Scaling Postgres 30
Sep 17, 2018
Parallel Indexing, SQL vs. ORM, Logical Replication Upgrades | Scaling Postgres 29
Sep 10, 2018
Watch, Fast Text Search, Column Defaults, Import CSVs | Scaling Postgres 28
Sep 03, 2018
Multiple Databases, Slow Queries, Sorting Performance | Scaling Postgres 27
Aug 27, 2018
Join Costs, zHeap, Autovacuum Tuning | Scaling Postgres 26
Aug 20, 2018
generate_series, PG11 Partitioning, GPU Queries | Scaling Postgres 25
Aug 13, 2018
Full Text Search, JSONB_AGG, Upgrades, CIS | Scaling Postgres 24
Aug 06, 2018
UUIDs, Write Spikes, Distinct, SQL Standard | Scaling Postgres 23
Jul 30, 2018
Concurrency, Listen & Notify, ZFS, pg_rewind | Scaling Postgres 22
Jul 23, 2018
Using JSON, Procedures, Concurrency, Kubernetes | Scaling Postgres 21
Jul 16, 2018
Declarative Partitioning, Permissions, Trigger Speed | Scaling Postgres 20
Jul 09, 2018
100K Tenants, Extensions, Query Planning, Crosstabs | Scaling Postgres 19
Jul 02, 2018
Impact of Virtualization, Compressing Data, Parallelism | Scaling Postgres 18
Jun 25, 2018
Real Time Analytics, Index Decrease Performance, work_mem | Scaling Postgres 17
Jun 18, 2018
Storing Bits, Autovacuum, Assertions, Logical Recovery | Scaling Postgres 16
Jun 11, 2018
Leveraging Postgres, Tuning Autovacuum, Slow Queries | Scaling Postgres 15
Jun 04, 2018
Postgres 11, Multi-tenant Scale, Trigger Speed, Full Text Search | Scaling Postgres 14
May 28, 2018
Sharding Future, Query Optimization, Replication Read Performance, PostGIS | Scaling Postgres 13
May 21, 2018
The Future, Slow Counts, Avoid Or, Replication | Scaling Postgres 12
May 14, 2018
Serializable, JSON & JSONB, Fast Data Loading, PG11 Features | Scaling Postgres 11
May 07, 2018
ANSI Schmansi, Split-Brain, Performance Scenarios, Parallelism | Scaling Postgres 10
Apr 30, 2018
High Volume Processing, pg_wal Issues, Restore with pg_receivewal | Scaling Postgres 9
Apr 23, 2018
Scaling Real-Time Analytics, Covering Indexes, 1,500 Upgrades | Scaling Postgres 8
Apr 16, 2018
Any Scale, Monitoring Vacuum, Copy, Annotated Config | Scaling Postgres 7
Apr 09, 2018
Terabyte Scale, Permissions, Fast Column Adds, pgBouncer | Scaling Postgres 6
Apr 02, 2018
Constraints, User Order, PG Terrible, Logical Upgrades | Scaling Postgres 5
Mar 26, 2018
50TB Upgrade, Vacuum, DB Security | Scaling Postgres 4
Mar 19, 2018
Modeling, Query Performance, Statistics, pgmetrics | Scaling Postgres 3
Mar 12, 2018
Analytical DBs, Recursive Queries, Replication | Scaling Postgres 2
Mar 05, 2018
Petabyte Scale and Locking | Scaling Postgres 1
Feb 27, 2018