Postgres Weekly

Issue archive

#648 Don't pretend your Postgres views are tables 2026-05-13

#647 Postgres 19's most exciting features 2026-05-06

#646 pgBackRest is no longer being maintained 2026-04-29

#645 A Kafka-like pure SQL queue for Postgres 2026-04-22

#644 A 6502 CPU emulator entirely in Postgres 2026-04-15

#643 ClickHouse's new benchmark for Postgres services 2026-04-08

#642 pg_textsearch 1.0 brings production-ready BM25 to Postgres 2026-04-01

#641 Moving one word in a query unlocks a 32x speedup 2026-03-25

#640 How one query ate 2 TB of RAM 2026-03-18

#639 Robert Haas proposes pg_plan_advice for Postgres 19 2026-03-11

#638 Postgres releases 18.3, 17.9, 16.13 to fix regressions 2026-03-04

#637 The tale of an unanticipated concurrency and locking gotcha 2026-02-25

#636 Postgres 18.2 released (but you may want to wait) 2026-02-18

#635 An offline Postgres expert-in-a-box 2026-02-11

#634 Finally, a decent way to browse pgsql-hackers 2026-02-04

#633 Millions of queries per second, one Postgres primary, at OpenAI 2026-01-28

#632 Three unconventional Postgres optimizations 2026-01-21

#631 Using Postgres as a graph database with Apache AGE 2026-01-14

#630 Latency's huge impact on Postgres performance 2026-01-07

#629 pg_textsearch, a newly open-sourced BM25 implementation 2025-12-18

#628 What the different scan types in EXPLAIN plans do 2025-12-11

#627 Bringing transparent data encryption (TDE) to Postgres 18 2025-12-04

#626 Postgres 19 to bring even more performance for free 2025-11-27

#625 Amazon RDS now supports Postgres 18 2025-11-20

#624 Today is Postgres 13's final day 2025-11-13

#623 A counterintuitive result of giving Postgres more memory 2025-11-06

#622 Kafka is fast, but Postgres will do 2025-10-30

#621 Another free Postgres hosting option arrives 2025-10-23

#620 Benchmarking Postgres 17 vs 18 2025-10-16

#619 How to get started with building and debugging Postgres 2025-10-09

#618 Pipelining comes to `psql` in Postgres 18 2025-10-02

#617 Postgres 18 released 2025-09-25

#616 Sharding a Postgres database without downtime 2025-09-18

#615 OrioleDB's patent now available to the Postgres community 2025-09-11

#614 Postgres 18 enters the Release Candidate stage 2025-09-04

#613 Big steps forward for DocumentDB 2025-08-28

#612 A fantastic guide to logging in Postgres 2025-08-21

#611 The different types of log sequence numbers 2025-08-07

#610 Making Postgres much slower (and faster!) 2025-07-31

#609 Using Postgres as a high-scale queue 2025-07-24

#608 Postgres providers chew over PlanetScale's benchmarks 2025-07-17

#607 My server! The SIGTERMs do nothing! 2025-07-10

#606 PlanetScale joins the Postgres party 2025-07-03

#605 Interesting bits of Postgres grammar 2025-06-26

#604 An elephant and a duck walk into a bar.. 2025-06-19

#603 Vitess is coming to Postgres 2025-06-12

#602 Postgres config settings for humans 2025-05-29

#601 Bringing Postgres to VS Code 2025-05-22

#600 Postgres 18 features to take note of 2025-05-15

#599 Lots of Postgres 18 news 2025-05-08

#598 A WebAssembly build of Postgres 17 2025-05-01

#597 User, User, Who is the User? 2025-04-24

#596 It's time to learn 2025-04-10

#595 Comparing Postgres and SQL Server's indexing approaches 2025-04-03

#594 Life altering Postgres patterns 2025-03-27

#593 A future of AI agents monitoring your Postgres? 2025-03-20

#592 How about 1 trillion rows in Postgres? 2025-03-13

#591 Postgres query plan visualization tools 2025-03-06

#590 Bruce Momjian's Postgres tour 2025-02-27

#589 Postgres in the time of monster hardware 2025-02-20

#588 Is it time for trailing commas in SQL? 2025-02-13

#587 Microsoft's BSON document NoSQL database on Postgres 2025-02-06

#586 Doing an Aurora Postgres upgrade without downtime 2025-01-30

#585 See every byte of a Postgres query made over the network 2025-01-23

#584 Don't do this in Postgres (but do open this newsletter) 2025-01-16

#583 A top cause of slow Postgres queries 2025-01-09

#582 How 2024 went for Postgres 2024-12-18

#581 7+ million Postgres tables without flinching 2024-12-11

#580 Amazon teases a new Postgres(ish) service 2024-12-04

#579 INSERT vs COPY for batch ingestion 2024-11-27

#578 Adding an SQLite column type to Postgres 2024-11-20

#577 Now you can enjoy Postgres Europe 2024 too 2024-11-13

#576 They moved from Postgres to MySQL? 2024-11-06

#575 A better way to search the Postgres docs 2024-10-30

#574 SQL/JSON borne 2024-10-16

#573 Optimizing queries before planning 2024-10-09

#572 Are you qualified to use NULL? 2024-10-02

#571 Postgres 17 has entered the building 2024-09-27

#570 Identity columns: a SERIAL killer? 2024-09-18

#569 The Tetris effect 2024-09-11

#568 The State of PostgreSQL survey is back 2024-09-04

#567 Functions, functions, everywhere? 2024-08-28

#566 Postgres 17 is just a month away.. 2024-08-21

#565 The fastest way to copy data between tables 2024-07-31

#564 Speeding up index creation 2024-07-24

#563 We're all in charge of Postgres 2024-07-17

#562 Let's get talking Postgres 2024-07-10

#561 How Notion took Postgres to the data lake 2024-07-03

#560 Tuning parameters vs tuning your queries 2024-06-26

#559 Reflections on recent Postgres events 2024-06-19

#558 A big boost to vector performance with pgvectorscale 2024-06-12

#557 The biggest Postgres hiatus in 20 years, but.. 2024-06-05

#556 Heroku goes to Amazon Aurora 2024-05-22

#555 The draft Postgres 17 release notes 2024-05-15

#554 Understanding Postgres' schemas 2024-05-08

#553 pgvector gets even better 2024-05-01

#552 The future of MySQL is.. Postgres? 2024-04-24

#551 Early excitement for Postgres 17 2024-04-17

#550 PopSQL joins Timescale 2024-04-10

#549 Making a first contribution to Postgres 2024-04-03

#548 Will Postgres ever 'pull a Redis'? 2024-03-27

#547 An experimental JIT compiler for Postgres 2024-03-20

#546 pgvector Indexes and Optimizations 2024-03-13

#545 A new list of AI related Postgres resources 2024-03-06

#544 Postgres in WebAssembly 2024-02-28

#543 Some SQL optimizations 2024-02-21

#542 PG 16's query planning enhancements 2024-02-14

#541 Doing everything with Postgres 2024-02-07

#540 Even better robots writing SQL 2024-01-31

#539 Let's talk pgvector 2024-01-24

#538 A new monster of an SQL query 2024-01-17

#537 Postgres - the database of the year in 2023 2024-01-10

#536 The top Postgres items of the past year 2024-01-03

#535 The final Postgres roundup of 2023 2023-12-20

#534 PostgREST 12, Supavisor 1.0, and pg_graphql 1.4 2023-12-13

#533 Heroku Postgres switching to Amazon Aurora? 2023-12-06

#532 AWS's 'limitless' Postgres scaling 2023-11-29

#531 Postgres 16 goes GA on AWS RDS and Azure 2023-11-22

#530 Eight Postgres extensions worth knowing 2023-11-15

#529 Simple SQL queries that'll get you thinking 2023-11-08

#528 A new serverless Postgres platform appears 2023-11-01

#527 Citus goes deep in its technical README 2023-10-25

#526 Putting your money where your SQL is 2023-10-18

#525 An alternative full-text search option 2023-10-11

#524 Microsoft's Postgres-themed coloring book 2023-10-04

#523 Oracle gets into the Postgres game 2023-09-27

#522 The one with Postgres 16 2023-09-20

#521 Why people (should) care about PostGIS 2023-09-13

#520 pgvector 0.5 and Postgres 16 RC1 released 2023-09-06

#519 Benchmarking 1 million concurrent connections 2023-08-16

#518 A Postgres language server 2023-08-09

#517 Locks, partitioning, and bulk loading 2023-08-02

#516 Tips, tips, and more PG tips 2023-07-26

#515 A vacuum-free future for Postgres? 2023-07-19

#514 A recipe for changing a column's type live 2023-07-12

#513 Postgres 16 beta 2 2023-07-05

#512 Vectors are the new JSON 2023-06-28

#511 Postgres finally takes the #1 spot 2023-06-21

#510 To thread, or not to thread? It's a huge question 2023-06-14

#509 Summer reading tip: the SQL:2023 spec 2023-06-07

#508 Postgres 16 beta 1 released 2023-05-31

#507 Amazon RDS adds PL/Rust 2023-05-24

#506 Amazon RDS adds pgvector support 2023-05-17

#505 🐘 Why Postgres's mascot is an elephant 2023-05-10

#504 Why Andy Pavlo dislikes Postgres's MVCC 2023-05-03

#503 Postgres mistakes to avoid 2023-04-26

#502 A package manager for Postgres? 2023-04-19

#501 JSONB cheat sheet 2023-04-12

#500 Now you can write Postgres functions in Rust 2023-04-05

#499 Getting Postgres ready for production 2023-03-29

#498 The Postgres rabbit hole goes deep 2023-03-22

#497 A fantastic Postgres book 2023-03-15

#496 When the WAL wouldn't stop growing 2023-03-08

#495 Why GitHub stuck with MySQL over Postgres early on 2023-03-01

#494 'The real billion dollar mistake is ignoring Postgres..' 2023-02-22

#493 How to expose Postgres performance issues 2023-02-15

#492 FILTER vs CASE 2023-02-08

#491 April is the month for Postgres events 2023-02-01

#490 How to work on the Postgres source code 2023-01-25

#489 JSON Postgresly 2023-01-18

#488 Postgres as an 'everything interface' 2023-01-11

#487 We're back, with some Postgres hidden gems. 2023-01-04

#486 The best of Postgres Weekly in 2022 2022-12-21

#485 Are Postgres committers morning people? 2022-12-14

#484 Postgres extensions even Amazon can trust 2022-12-07

#483 When a two column index is better than one 2022-11-30

#482 Unfeathering one's nest with UNNEST 2022-11-23

#481 This is the greatest database in the world.. tribute. 2022-11-16

#480 You know I'd run a billion transactions.. 2022-11-09

#479 B-tree vs BRIN 2022-11-02

#478 Azure takes Postgres into the Cosmos 2022-10-26

#477 The Postgres 15 afterglow 2022-10-19

#476 🎉 Postgres 15 has been released 2022-10-13

#475 The imminence of Postgres 15 2022-10-12

#474 A surprisingly jam packed issue 2022-10-05

#473 SQLite to Postgres and how it's difficult to do 2022-09-28

#472 Rust's benefits for building Postgres extensions 2022-09-21

#471 How to monitor Postgres's network usage 2022-09-14

#470 SQL/JSON snoozes till Postgres 16 2022-09-07

#469 A potpourri of Postgres 15 progressions. 2022-08-31

#468 How to corrupt your database (so you won't) 2022-08-24

#467 A sample database for Postgres. 2022-08-10

#466 Tips for keeping your vacuum running well. 2022-08-03

#465 Using row level security for safer multi-tenant SaaS. 2022-07-27

#464 The power of \gexec 2022-07-20

#463 🎧 Postgres gets a new podcast 2022-07-13

#462 A fresh beta of Postgres 15 2022-07-06

#461 Google on Postgres as a database API standard. 2022-06-29

#460 Embrace, extend, and open source? Citus opens up even more. 2022-06-22

#459 Postgres 14 release due tomorrow to fix concurrent indexing bug 2022-06-15

#458 Reducing read I/O with range partitioning 2022-06-08

#457 A new Postgres platform opens its source 2022-06-01

#456 Postgres 15 beta 1 released 2022-05-25

#455 The draft release notes for Postgres 15 2022-05-18

#454 Throw your data in a lake 2022-05-11

#453 AWS's 1 terabyte of RAM for Postgres 2022-05-04

#452 Amazon Aurora Serverless v2 now available 2022-04-27

#451 A Postgres 9 to 13 upgrade story 2022-04-20

#450 PostGIS for newbies 2022-04-13

#449 How Postgres chooses which indexes to use 2022-04-06

#448 MERGEing into Postgres 15 2022-03-30

#447 Tuning max_wal_size for performance 2022-03-23

#446 Full of frammishes 2022-03-16

#445 Now we're even using SQL to cheat at Wordle 2022-03-09

#444 A promising new storage engine for Postgres 2022-03-02

#443 Going deep into trigram-based text search 2022-02-23

#442 A great Postgres firefighting story 2022-02-16

#441 Through the wire (protocol) 2022-02-09

#440 It's about time 2022-02-02

#439 Super fast Postgres database cloning 2022-01-26

#438 Bottlenecks and progress bars (again) 2022-01-19

#437 A last look at what 2021 brought to Postgres 2022-01-12

#436 What clicked in 2021. 2021-12-22

#435 Postgres powering a key UK medical dashboard 2021-12-15

#434 A new way to bring GraphQL into Postgres 2021-12-08

#433 Did you know about EXCEPT ALL? 2021-12-01

#432 Does EAV make any sense in Postgres? 2021-11-24

#431 Why pg_auto_failover is an awesome project 2021-11-17

#430 Lesser known Postgres features 2021-11-10

#429 Babelfish arrives; now open source 2021-11-03

#428 Making PL/pgSQL a little less scary 2021-10-27

#427 Balancing query time vs relevancy with text search 2021-10-20

#426 Notion's Postgres sharding story 2021-10-13

#425 Postgres 14 Released 2021-10-06

#424 Postgres 14 RC 1 released; final due very soon 2021-09-29

#423 The little things about Postgres 14 2021-09-22

#422 A Postgres GUI client roundup 2021-09-15

#421 It pays to get max_connections right 2021-09-08

#420 A deep dive into the perils of subtransactions 2021-09-01

#419 Do you even need a separate cache? 2021-08-25

#418 How the network can affect query performance 2021-08-11

#417 pg_timetable 4.0 released 2021-08-04

#416 Play armchair quarterback with Postgres 2021-07-28

#415 Generating JSON direct from Postgres 2021-07-21

#414 A tool to critique your Postgres schemas 2021-07-14

#413 A way to simulate time travel on your database 2021-07-07

#412 Postgres 14 beta 2 released 2021-06-30

#411 How to become a Postgres contributor 2021-06-23

#410 Do you need Redis if you have Postgres? 2021-06-16

#409 Using JavaScript in Postgres procedures 2021-06-09

#408 Postgres, it's getting better.. a little better all the time. 2021-06-02

#407 Postgres 14 beta 1 released 2021-05-26

#406 The state of Postgres survey results are in 2021-05-19

#405 Using Postgres as a data warehouse 2021-05-12

#404 Listening to Postgres changes in real time 2021-05-05

#403 The internals of hash indexes 2021-04-28

#402 Amazon RDS for Postgres can now call Lambda functions 2021-04-21

#401 Comparing RDS and Aurora for Postgres users 2021-04-14

#400 psql tips 2021-04-07

#399 Speed, speed, and speed 2021-03-31

#398 A library for parsing and deparsing Postgres queries 2021-03-24

#397 AWS Aurora offering ARM for a Postgres performance boost 2021-03-17

#396 Columnar storage for Postgres with Citus 10 2021-03-10

#395 How to estimate an ideal connection pool size 2021-03-03

#394 Fuzzy string searching 2021-02-24

#393 The Babelfish / Postgres integration question 2021-02-17

#392 More Postgres database cleaning 2021-02-10

#391 Freeing up unused space in your databases 2021-02-03

#390 Strong ARM Postgres 2021-01-27

#389 Two hierarchical data modelling approaches in Postgres 2021-01-20

#388 How hash indexes can actually be good 2021-01-13

#387 Idle connections 2021-01-06

#386 The most popular Postgres items of 2020 2020-12-16

#385 The tale of two little regexes 2020-12-09

#384 Saying hello to the SQL Server users 2020-12-02

#383 Postgres is the 'batteries included' database 2020-11-25

#382 New security releases of Postgres all round 2020-11-18

#381 Are Postgres and MongoDB best friends? 2020-11-11

#380 Two new Postgres core team members 2020-11-04

#379 Using Postgres alone to shape and prepare data 2020-10-28

#378 How medium-sized text columns can impact table performance 2020-10-21

#377 Testing the limits of Postgres's connection scalability 2020-10-14

#376 Benchmarking queries, EDB buys 2ndQuadrant, and Azure's flexible Postgres service 2020-10-07

#375 Postgres 13 released 2020-09-30

#374 First release candidate of Postgres 13 released 2020-09-23

#373 Best practices for bulk data loading in Postgres 2020-09-16

#372 The effect B-tree index deduplication has in Postgres 13 2020-09-09

#371 Parallelism, vacuuming, and trusted extensions 2020-09-02

#370 Why 13 will be a lucky number for Postgres 2020-08-26

#369 New bug fix Postgres releases, and Envoy gets Postgres monitoring support 2020-08-19

#368 Pagination, backtraces, and going beyong JSONB 2020-08-12

#367 An introduction to SCRAM authentication in Postgres 13 2020-08-05

#366 Fill factors, SQL style, and figuring out prices in Postgres 2020-07-29

#365 Recreating a location based social network with Postgres 2020-07-22

#364 A way to build Postgres extensions in Rust 2020-07-15

#363 Amazon RDS now lets you take Postgres from outhouse to inhouse 2020-07-08

#362 Testing Postgres extensions with Docker and GitHub Actions 2020-07-01

#361 Unifying JSON and JSONB into a new JSON type 2020-06-24

#360 How 'RETURNING' yielded a 9x performance improvement 2020-06-17

#359 How to make those EXPLAIN ANALYZE plans more readable 2020-06-10

#358 A deep dive into various types of locks in Postgres 2020-06-03

#357 Postgres 13 beta 1 released 2020-05-27

#356 Comparing the ways to store binary data with Postgres 2020-05-20

#355 Don't modify Postgres's data directory 2020-05-13

#354 Medium-hard SQL questions to think about 2020-05-06

#353 Workloads, acceleration, and making Postgres better 2020-04-29

#352 The one where we interviewed Luca Ferrari 2020-04-22

#351 An intro to making Postgres high availability on Kubernetes 2020-04-15

#350 Reflecting on Postgres's weaknesses 2020-04-08

#349 AWS RDS now supports Postgres 12 2020-04-01

#348 Job scheduler pg_timetable hits 2.0 2020-03-25

#347 Understanding Recursive SQL Queries 2020-03-18

#346 Safer Postgres migrations for Rubyists, and some golden oldies 2020-03-11

#345 A Web Tool to Create Postgres Configuration Settings 2020-03-04

#344 Locks, backups, and parallelism: Keeping an eye on Postgres 2020-02-26

#343 A security issue forces new releases of Postgres all round 2020-02-19

#342 psql + gnuplot = CLI Graphs From Your Data 2020-02-12

#341 The state of full-text search in Postgres 12 2020-02-05

#340 There's a new powerful Postgres job scheduler in town 2020-01-29

#339 Vacuuming in parallel coming to Postgres 13 2020-01-22

#338 Two edge cases in Postgres's full-text search 2020-01-15

#337 Using HyperLogLog functions in Postgres 2020-01-08

#336 The top Postgres links of 2019 2019-12-18

#335 The state of Postgres survey results are in 2019-12-11

#334 Some lesser known features in Postgres 12 2019-12-04

#333 B-Tree Index Improvements in Postgres 12 2019-11-27

#332 Postgres 12.1, 11.6, 10.11, and others released 2019-11-20

#331 Making Mystery-Solving Easier with `auto_explain` 2019-11-13

#330 This week's Postgres news 2019-11-06

#329 Upgrades, computed columns, and more Postgres 12 goodies 2019-10-30

#328 PostGIS 3.0 released 2019-10-23

#327 How to pre-warm Postgres's I/O caches 2019-10-16

#326 Postgres 12 is here 2019-10-09

#325 Postgres 12 is imminent 2019-10-02

#324 A look at Postgres's window frames 2019-09-25

#323 Postgres 12 Beta 4 released 2019-09-18

#322 Pros and cons of different Postgres upgrade methods 2019-09-11

#321 How Postgres 12 improves performance 2019-09-04

#320 Working with row level security in Postgres 2019-08-28

#319 Building faster Postgres trigger functions in C 2019-08-21

#318 Postgres 12 beta 3, 11.5, 10.10, and more released 2019-08-14

#317 Ever wanted to create a Postgres extension in C? 2019-08-07

#316 Considering combined vs separate indexes in Postgres 2019-07-31

#315 How one of the world's largest classifieds sites scales Postgres 2019-07-24

#314 How to upgrade your Postgres passwords to SCRAM 2019-07-17

#313 Postgres goes serverless with Amazon Aurora 2019-07-10

#312 A dive into Postgres's default settings and their impact on security 2019-07-03

#311 New releases of Postgres to fix a security vulnerability 2019-06-26

#310 Linear interpolation with Postgres 2019-06-19

#309 COPY to gain a WHERE condition in Postgres 12 2019-06-12

#308 A periodic table of `psql` commands 2019-06-05

#307 Postgres 12 Beta 1 Released 2019-05-29

#306 Things to avoid doing when using Postgres 2019-05-22

#305 New Postgres releases, and how to live on the Postgres edge 2019-05-15

#304 Citus becomes 'Hyperscale' on Azure 2019-05-08

#303 The deepest dive into GIN indexes you'll ever see 2019-05-01

#302 Creating fractals with SQL and Postgres 2019-04-24

#301 Pluggable table storage coming to Postgres? 2019-04-17

#300 Faster counting in Postgres, PGCon 2019, and some handy tools 2019-04-10

#299 A report on the latest Postgres trends 2019-04-03

#298 AWS RDS and Heroku now support Postgres 11 2019-03-27

#297 Approaches for vertically scaling Postgres 2019-03-20

#296 Don't let locking block Postgres's autovacuum 2019-03-13

#295 PostgreSQL tools for the visually inclined 2019-03-06

#294 How to see how much space your tables are using 2019-02-27

#293 Postgres 11 makes Postgres the leader in window functions again 2019-02-20

#292 How Postgres used fsync() incorrectly for 20 years 2019-02-13

#291 Making schema changes in Postgres without downtime 2019-02-06

#290 Microsoft acquires Citus Data 2019-01-30

#289 How to use an exclusion constraint to prevent overlapping date ranges 2019-01-23

#288 The origin and background story of Postgres 2019-01-16

#287 The Guardian: Bye Bye Mongo, Hello Postgres 2019-01-09

#286 This year in the world of Postgres 2018-12-19

#285 How to Upgrade Postgres 10 to 11 with Zero Downtime 2018-12-12

#284 Installing and Configuring JIT in Postgres 11 2018-12-05

#283 How extensions make Postgres much more powerful 2018-11-28

#282 PipelineDB 1.0: High-Performance Time-Series Aggregation for PG 11 2018-11-14

#281 Materialized Views vs. Rollup Tables in Postgres 2018-11-07

#280 PostgreSQL Anonymizer: A Tool to Mask Personal Information 2018-10-31

#279 PostgreSQL 11 released: A look at what's new 2018-10-24

#278 PostgreSQL 11 Release Candidate 1 Released 2018-10-17

#277 PostGraphile v4 Released: A GraphQL API for Your Database 2018-10-10

#276 Why The European Space Agency Uses Postgres 2018-10-03

#275 Postgres 11 beta 4 and PostGIS 2.5.0 released 2018-09-26

#274 The Major Features in Postgres 11 2018-09-19

#273 Setting up Streaming Replication in Postgres 2018-09-12

#272 Tuning Postgres' Parameters to Optimize Performance 2018-09-05

#271 A Missing Link in Postgres 11: Fast Column Creation with Defaults 2018-08-29

#270 3 Ways to Detect Slow Queries in Postgres 2018-08-22

#269 The cost of a JOIN, plus some new Postgres releases 2018-08-15

#268 Understanding and Reading the Postgres System Catalog 2018-08-08

#267 Triggers and Stored Function Basics 2018-08-01

#266 How Postgres's SQL Dialect Stays Ahead of Its Competitors 2018-07-25

#265 Gracefully Scaling to 10k Postgres Connections for Cheap 2018-07-18

#264 An intro to JSON data types in PostgreSQL 2018-07-11

#263 PostgreSQL 11 Beta 2 Released 2018-07-04

#262 Architecture and Tuning of Memory in Postgres Databases 2018-06-27

#261 Postgres Features You May Not Have Tried But Should 2018-06-20

#260 Configuring Memory for Postgres 2018-06-13

#259 Fun with SQL: Window Functions in Postgres 2018-06-06

#258 PostgreSQL 11 Beta 1 Released 2018-05-30

#257 Selecting All Columns Except One in Postgres 2018-05-23

#256 Postgres 10.4 released, and having fun with recursive CTEs 2018-05-16

#255 High Availability and Scalable Reads in Postgres 2018-05-09

#254 #254: An example of Postgres 11's CREATE PROCEDURE 2018-05-02

#253 #253: Postgres 10, Performance and You 2018-04-25

#252 #252: Backup Tools for Postgres 2018-04-18

#251 #251: The Story of A Mega Postgres 10 Upgrade 2018-04-11

#250 #250: New Annotated Config Files for Postgres 10 2018-04-04

#249 Alert and Notification Tools for Postgres 2018-03-28

#248 #248: Using pg_badplan to CREATE STATISTICS 2018-03-21

#247 #247: Postgres is the most loved RDBMS 2018-03-14

#246 #246: The Postgres 10 feature you didn't know about 2018-03-07

#245 #245: Tips for dealing with Postgres locks 2018-02-28

#244 #244: Understanding locks and row level security in Postgres 2018-02-21

#243 #243: Intro to PostgreSQL Automatic Failover 2018-02-14

#242 #242: Postgres's Hidden Gems 2018-02-07

#241 #241: Principles and Applications of Postgres's Index Types 2018-01-31

#240 #240: Experiences with Running Postgres on Kubernetes 2018-01-24

#239 #239: PostgreSQL Meltdown - What's The Effect on Performance? 2018-01-17

#238 #238: PostgreSQL is DB Engines' 'DBMS of the Year' 2017 2018-01-10

#237 The biggest Postgres news in 2017 2017-12-20

#236 #236: Reducing Disk Bloat with pg_repack 2017-12-13

#235 #235: Postgres 11 Adding Support for 'SQL Procedures 2017-12-06

#234 #234: Visualizing and Tuning Postgres's 'Autovacuum' 2017-11-29

#233 #233: Upgrading From 9.6 to 10 with Minimal Downtime using pglogical 2017-11-15

#232 #232: Five Novelties in PostgreSQL 10 2017-11-08

#231 #231: Monitoring Your Bloat in Postgres 2017-11-01

#230 #230: Postgres 10 vs. TimescaleDB for Time-Series Data 2017-10-25

#229 🐘 #229: A Tour of Postgres Index Types 2017-10-18

#228 #228: PostgreSQL 10 Released 2017-10-11

#227 #227: A Postgres Concurrency Deep Dive 2017-10-04

#226 #226: PostgreSQL 10 RC1 Released 2017-09-27

#225 #225: Tracking and Managing Your Postgres Connections 2017-09-20

#224 #224: Better Database Migrations in Postgres 2017-09-13

#223 #223: Postgres Backups, Logical vs. Physical 2017-09-06

#222 #222: Deferrable SQL Constraints in Depth 2017-08-30

#221 #221: WAL-G - Faster Disaster Recovery for Postgres 2017-08-23

#220 #220: Plans for Partitioning in Postgres 11 2017-08-16

#219 #219: PgHero 2.0 - A Performance Dashboard for Postgres 2017-08-09

#218 #218: Implementing State Machines in Postgres 2017-08-02

#217 #217: Writing Your Own Aggregation Functions 2017-07-26

#216 #216: PostgreSQL 10 Beta 2 Released 2017-07-19

#215 #215: A Tool to Create Hypothetical Indexes in Postgres 2017-07-12

#214 #214: How to Use Ansible to Manage Postgres 2017-07-05

#213 #213: Dexter - An Automatic Indexer for Postgres 2017-06-28

#212 #212: DynamoDB to Postgres: Why and How 2017-06-21

#211 #211: PG-Strom: SSD-To-GPU Direct SQL Execution for Postgres 2017-06-14

#210 #210: Scaling Out Complex SQL Transactions in Multi-Tenant Apps 2017-06-07

#209 #209: Postgres 10's New Features with Examples 2017-05-31

#208 #208: PostgreSQL 10 Beta 1 Released 2017-05-24

#207 #207: Postgres's May 2017 Security Update Release 2017-05-17

#206 #206: When Postgres Is Not Enough 2017-05-10

#205 #205: Logical replication in Postgres 10, and the pg_stat_user_indexes table 2017-05-03

#204 This Week's PostgreSQL News (#204) 2017-04-26

#203 #203: Speeding up Postgres Restores 2017-04-19

#202 This Week's PostgreSQL News (#202) 2017-04-12

#201 The PostgreSQL Security Technical Implementation Guide (#201) 2017-04-05

#200 This Week's PostgreSQL News (#200) 2017-03-29

#199 This Week's PostgreSQL News (#199) 2017-03-22

#198 This Week's PostgreSQL News (#198) 2017-03-15

#197 This Week's PostgreSQL News (#197) 2017-03-08

#196 This Week's PostgreSQL News (#196) 2017-03-01

#195 This Week's PostgreSQL News (#195) 2017-02-22

#194 This Week's PostgreSQL News (#194) 2017-02-15

#193 This Week's PostgreSQL News (#193) 2017-02-08

#192 This Week's PostgreSQL News (#192) 2017-02-01

#191 This Week's PostgreSQL News (#191) 2017-01-25

#190 This Week's PostgreSQL News (#190) 2017-01-18

#189 This Week's PostgreSQL News (#189) 2017-01-11

#188 This Week's PostgreSQL News (#188) 2017-01-04

#187 PostgresApp 2.0, plus a 2016 PostgreSQL Roundup 2016-12-21

#186 This Week's PostgreSQL News (#186) 2016-12-14

#185 Postgres + GraphQL = PostGraphQL 2016-12-07

#184 This Week's PostgreSQL News (#184) 2016-11-30

#183 This Week's PostgreSQL News (#183) 2016-11-16

#182 This Week's PostgreSQL News (#182) 2016-11-09

#181 This Week's PostgreSQL News (#181) 2016-11-02

#180 This Week's PostgreSQL News (#180) 2016-10-26

#179 This Week's PostgreSQL News (#179) 2016-10-19

#178 This Week's PostgreSQL News (#178) 2016-10-12

#177 This Week's PostgreSQL News (#177) 2016-10-05

#176 Postgres 9.6 has just been released 2016-09-29

#175 This Week's PostgreSQL News (#175) 2016-09-21

#174 This Week's PostgreSQL News (#174) 2016-09-14

#173 This Week's PostgreSQL News (#173) 2016-09-07

#172 This Week's PostgreSQL News (#172) 2016-08-31

#171 This Week's PostgreSQL News (#171) 2016-08-24

#170 This Week's PostgreSQL News (#170) 2016-08-17

#169 A look at Postgres index internals, and benchmarking Postgres on different Linux kernel versions 2016-08-10

#168 This Week's PostgreSQL News (#168) 2016-08-03

#167 This Week's PostgreSQL News (#167) 2016-07-27

#166 Moving from a graph database to Postgres, When to use Hstore, JSON and JSONB 2016-07-20

#165 This Week's PostgreSQL News (#165) 2016-07-13

#164 This Week's PostgreSQL News (#164) 2016-07-06

#163 This Week's PostgreSQL News (#163) 2016-06-29

#162 This Week's PostgreSQL News (#162) 2016-06-22

#161 This Week's PostgreSQL News (#161) 2016-06-15

#160 This Week's PostgreSQL News (#160) 2016-06-08

#159 This Week's PostgreSQL News (#159) 2016-06-01

#158 This Week's PostgreSQL News (#158) 2016-05-25

#157 This Week's PostgreSQL News (#157) 2016-05-18

#156 This Week's PostgreSQL News (#156) 2016-05-11

#155 This Week's PostgreSQL News (#155) 2016-05-04

#154 This Week's PostgreSQL News (#154) 2016-04-27

#153 This Week's PostgreSQL News (#153) 2016-04-20

#152 This Week's PostgreSQL News (#152) 2016-04-13

#151 This Week's PostgreSQL News (#151) 2016-04-06

#150 This Week's PostgreSQL News (#150) 2016-03-30

#149 This Week's PostgreSQL News (#149) 2016-03-23

#148 This Week's PostgreSQL News (#148) 2016-03-16

#147 This Week's PostgreSQL News (#147) 2016-03-09

#146 This Week's PostgreSQL News (#146) 2016-03-02

#145 This Week's PostgreSQL News (#145) 2016-02-24

#144 This Week's PostgreSQL News (#144) 2016-02-17

#143 This Week's PostgreSQL News (#143) 2016-02-10

#142 This Week's PostgreSQL News (#142) 2016-02-03

#141 This Week's PostgreSQL News (#141) 2016-01-27

#140 This Week's PostgreSQL News (#140) 2016-01-20

#139 This Week's PostgreSQL News (#139) 2016-01-13

#138 This Week's PostgreSQL News (#138) 2016-01-06

#137 This Week's PostgreSQL News (#137) 2015-12-30

#136 This Week's PostgreSQL News (#136) 2015-12-16

#135 This Week's PostgreSQL News (#135) 2015-12-09

#134 This Week's PostgreSQL News (#134) 2015-12-02

#133 This Week's PostgreSQL News (#133) 2015-11-25

#132 This Week's PostgreSQL News (#132) 2015-11-18

#131 This Week's PostgreSQL News (#131) 2015-11-11

#130 This Week's PostgreSQL News (#130) 2015-11-04

#129 This Week's PostgreSQL News (#129) 2015-10-28

#128 This Week's PostgreSQL News (#128) 2015-10-21

#127 This Week's PostgreSQL News (#127) 2015-10-14

#126 This Week's PostgreSQL News (#126) 2015-10-07

#125 This Week's PostgreSQL News (#125) 2015-10-01

#124 This Week's PostgreSQL News (#124) 2015-09-24

#123 This Week's PostgreSQL News (#123) 2015-09-16

#122 This Week's PostgreSQL News (#122) 2015-09-09

#121 This Week's PostgreSQL News (#121) 2015-09-02

#120 This Week's PostgreSQL News (#120) 2015-08-26

#119 This Week's PostgreSQL News (#119) 2015-08-19

#118 This Week's PostgreSQL News (#118) 2015-08-12

#117 This Week's PostgreSQL News (#117) 2015-08-05

#116 This Week's PostgreSQL News (#116) 2015-07-29

#115 This Week's PostgreSQL News (#115) 2015-07-22

#114 This Week's PostgreSQL News (#114) 2015-07-15

#113 This Week's PostgreSQL News (#113) 2015-07-08

#112 This Week's PostgreSQL News (#112) 2015-07-01

#111 This Week's PostgreSQL News (#111) 2015-06-24

#110 This Week's PostgreSQL News (#110) 2015-06-17

#109 This Week's PostgreSQL News (#109) 2015-06-10

#108 This Week's PostgreSQL News (#108) 2015-06-03

#107 This Week's PostgreSQL News (#107) 2015-05-27

#106 This Week's PostgreSQL News (#106) 2015-05-20

#105 This Week's PostgreSQL News (#105) 2015-05-13

#104 This Week's PostgreSQL News (#104) 2015-05-06

#103 This Week's PostgreSQL News (#103) 2015-04-29

#102 This Week's PostgreSQL News (#102) 2015-04-22

#101 This Week's PostgreSQL News (#101) 2015-04-15

#100 This Week's PostgreSQL News (#100) 2015-04-08

#99 This Week's PostgreSQL News (#99) 2015-04-01

#98 This Week's PostgreSQL News (#98) 2015-03-25

#97 This Week's PostgreSQL News (#97) 2015-03-18

#96 This Week's PostgreSQL News (#96) 2015-03-11

#95 This Week's PostgreSQL News (#95) 2015-03-04

#94 This Week's PostgreSQL News (#94) 2015-02-25

#93 This Week's PostgreSQL News (#93) 2015-02-19

#92 This Week's PostgreSQL News (#92) 2015-02-11

#91 This Week's PostgreSQL News (#91) 2015-02-04

#90 This Week's PostgreSQL News (#90) 2015-01-28

#89 This Week's PostgreSQL News (#89) 2015-01-21

#88 This Week's PostgreSQL News (#88) 2015-01-14

#87 This Week's PostgreSQL News (#87) 2015-01-07

#86 This Week's PostgreSQL News (#86) 2014-12-18

#85 This Week's PostgreSQL News (#85) 2014-12-10

#84 This Week's PostgreSQL News (#84) 2014-12-03

#83 This Week's PostgreSQL News (#83) 2014-11-26

#82 This Week's PostgreSQL News (#82) 2014-11-19

#81 none 2014-11-12

#80 This Week's PostgreSQL News (#80) 2014-11-05

#79 This Week's PostgreSQL News (#79) 2014-10-29

#78 This Week's PostgreSQL News (#78) 2014-10-21

#77 This Week's PostgreSQL News (#77) 2014-10-15

#76 This Week's PostgreSQL News (#76) 2014-10-08

#75 This Week's PostgreSQL News (#75) 2014-10-01

#74 This Week's PostgreSQL News (#74) 2014-09-24

#73 This Week's PostgreSQL News (#73) 2014-09-17

#72 This Week's PostgreSQL News (#72) 2014-09-10

#71 This Week's PostgreSQL News (#71) 2014-09-03

#70 This Week's PostgreSQL News (#70) 2014-08-27

#69 This Week's PostgreSQL News (#69) 2014-08-20

#68 This Week's PostgreSQL News (#68) 2014-08-13

#67 This Week's PostgreSQL News (#67) 2014-08-06

#66 This Week's PostgreSQL News (#66) 2014-07-30

#65 This Week's PostgreSQL News (#65) 2014-07-23

#64 This Week's PostgreSQL News (#64) 2014-07-09

#63 This Week's PostgreSQL News (#63) 2014-07-02

#62 This Week's PostgreSQL News (#62) 2014-06-18

#61 This Week's PostgreSQL News (#61) 2014-06-11

#60 This Week's PostgreSQL News (#60) 2014-06-04

#59 This Week's PostgreSQL News (#59) 2014-05-28

#58 This Week's PostgreSQL News (#58) 2014-05-21

#57 This Week's PostgreSQL News (#57) 2014-05-08

#56 This Week's PostgreSQL News (#56) 2014-05-01

#55 This Week's PostgreSQL News (#55) 2014-04-23

#54 This Week's PostgreSQL News (#54) 2014-04-16

#53 This Week's PostgreSQL News (#53) 2014-04-10

#52 This Week's PostgreSQL News (#52) 2014-04-03

#51 This Week's PostgreSQL News (#51) 2014-03-26

#50 This Week's PostgreSQL News (#50) 2014-03-19

#49 This Week's PostgreSQL News (#49) 2014-03-05

#48 This Week's PostgreSQL News (#48) 2014-02-26

#47 This Week's PostgreSQL News (#47) 2014-02-19

#46 This Week's PostgreSQL News (#46) 2014-02-13

#45 This Week's PostgreSQL News (#45) 2014-02-05

#44 This Week's PostgreSQL News (#44) 2014-01-29

#43 This Week's PostgreSQL News (#43) 2014-01-22

#42 This Week's PostgreSQL News (#42) 2014-01-15

#41 This Week's PostgreSQL News (#41) 2014-01-08

#40 This Week's PostgreSQL News (#40) 2013-12-18

#39 This Week's PostgreSQL News (#39) 2013-12-11

#38 This Week's PostgreSQL News (#38) 2013-12-04

#37 This Week's PostgreSQL News (#37) 2013-11-27

#36 This Week's PostgreSQL News (#36) 2013-11-20

#35 This Week's PostgreSQL News (#35) 2013-11-06

#34 This Week's PostgreSQL News (#34) 2013-10-30

#33 This Week's PostgreSQL News (#33) 2013-10-23

#32 This Week's PostgreSQL News (#32) 2013-10-16

#31 This Week's PostgreSQL News (#31) 2013-10-09

#30 This Week's PostgreSQL News (#30) 2013-10-02

#29 This Week's PostgreSQL News (#29) 2013-09-25

#28 This Week's PostgreSQL News (#28) 2013-09-18

#27 2013-09-11

#26 This Week's PostgreSQL News (#26) 2013-09-04

#25 This Week's PostgreSQL News (#25) 2013-08-28

#24 This Week's PostgreSQL News (#24) 2013-08-21

#23 This Week's PostgreSQL News (#23) 2013-08-14

#22 This Week's PostgreSQL News (#22) 2013-08-07

#21 This Week's PostgreSQL News (#21) 2013-07-31

#20 This Week's PostgreSQL News (#20) 2013-07-24

#19 This Week's PostgreSQL News (#19) 2013-07-17

#18 This Week's PostgreSQL Treats (#18) 2013-07-10

#17 This Week's PostgreSQL Treats (#17) 2013-07-03

#16 This Week's PostgreSQL Treats (#16) 2013-06-26

#15 This Week's PostgreSQL Treats (#15) 2013-06-19

#14 This Week's PostgreSQL Treats (#14) 2013-06-12

#13 This Week's PostgreSQL Treats (#13) 2013-06-05

#12 This Week's PostgreSQL Treats (#12) 2013-05-29

#11 This Week's PostgreSQL Treats (#11) 2013-05-22

#10 This Week's PostgreSQL Treats (#10) 2013-05-15

#9 This Week's PostgreSQL Treats (#9) 2013-05-08

#8 This Week's PostgreSQL Treats (#8) 2013-05-01

#7 This Week's PostgreSQL Treats (#7) 2013-04-24

#6 This Week's PostgreSQL Treats (#6) 2013-04-18

#5 This Week's PostgreSQL Treats (#5) 2013-04-10

#4 This Week's PostgreSQL Treats (#4) 2013-04-03

#3 This Week's PostgreSQL Treats (#3) 2013-03-27

#2 This Week's PostgreSQL Treats (#2) 2013-03-20

#1 This Week's PostgreSQL Treats (#1) 2013-03-13