Listen to a podcast, please open Podcast Republic app. Available on Google Play Store and Apple App Store.
cfchou
May 12, 2025
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 |