Pages

• Blog
• Services
  • Remote DBA for PostgreSQL
  • PostgreSQL Database Monitoring
  • PostgreSQL Health Check
  • PostgreSQL Performance Tuning
  • Global Database as a Service
  • PostgreSQL Database Security Audit
  • Upgrade PostgreSQL
  • PostgreSQL Migration Assessment
  • Migrate from Oracle to PostgreSQL
  • Kubernetes Orchestration for Highly Available PostgreSQL and BDR
  • Remote DBA for PostgreSQL
• Support
  • 24/7 PostgreSQL Support
  • IBM Z Production Support
    • Performance Analysis
  • Developer Support
• Products
  • BDR
    • IoT Solution
    • Postgres-BDR Deployment Options
    • BDR – The 3rd Generation
  • 2ndQPostgres
  • pglogical
    • Installation Instructions for pglogical
    • documentation
    • Release Notes
  • Replication & Failover Management for Postgres
    • Installation Instructions for repmgr
  • Barman
  • SQL Firewall
  • Postgres-XL
  • omniDB
  • Postgres Installer
  • 2UDA
    • Predictive Analytics with 2UDA
  • AXLE
  • PostgreSQL with High Availability
  • AlwaysOn Postgres
  • BDR
  • pgpredict – Predictive Analytics for PostgreSQL
    • pgpredict – Tutorial
  • Postgres Cloud Manager
• Webinars
• About 2ndQuadrant
• What Does “2ndQuadrant” Mean?
• News
  • February 15, 2019 – Announcing the release of OmniDB 2.14
  • February 4, 2019 – Barman v2.6 – Now with Support for Geo-redundancy
  • December 20, 2018 – Announcing the release of OmniDB 2.13
  • November 9, 2018 – Announcing Postgres Installer Updates for PostgreSQL 9.5, 9.6, 10 and 11
  • October 31, 2018 – 2ndQuadrant partners with frontrunner in online trading to boost PostgreSQL performance by 400%!
  • October 29, 2018 – pglogical 2.2.1 Released – Now with support for PostgreSQL 11
  • October 25, 2018 – Announcing the release of Postgres-XL 10R1
  • October 24, 2018 – repmgr 4.2 – Now with support for PostgreSQL 11
  • October 23, 2018 – Announcing the Release of OmniDB 2.12
  • October 23, 2018 – Barman v2.5 – Now with Support for PostgreSQL 11
  • October 19, 2018 – Postgres Installer – Now available for PostgreSQL 11
  • October 18, 2018 – 2ndQuadrant contributes major features to PostgreSQL 11
  • October 15, 2018 – Postgres Installer – Now Available for PostgreSQL 11 RC1
  • September 20, 2018 – Postgres Installer – Now Available for PostgreSQL 11 Beta 4
  • September 17, 2018 – Announcing the release of Postgres-XL 10R1Beta1
  • September 11, 2018 – Postgres Installer – Now with LDAP and Kerberos Support
  • September 5, 2018 – Announcing the Release of repmgr 4.1.1
  • August 23, 2018 – Announcing OmniDB 2.11 – Now with Support for PostgreSQL 11
  • August 21, 2018 – CFP deadline for 2ndQuadrant PostgreSQL Conference has been extended!
  • August 9, 2018 – Postgres Installer, now available with OmniDB Support
  • July 31, 2018 – Announcing the Release of repmgr 4.1
  • July 26, 2018 – Announcing the Release of OmniDB 2.10
  • July 10, 2018 – Postgres Installer, now available with PostGIS Support
  • June 29, 2018 – Announcing Postgres Installer for PostgreSQL 11 Beta 2
  • June 26, 2018 – Announcing the Release of BDR 1.0.6
  • June 19, 2018 – Announcing OmniDB 2.9 – Now with Plugin Support
  • June 14, 2018 – Announcing the Release of repmgr 4.0.6
  • June 07, 2018 – 2ndQuadrant PostgreSQL Conference 2018 officially opens Call for Papers and Registration
  • May 30, 2018 – 2ndQuadrant Postgres-BDR selected by leading Chilean telecommunications company
  • May 25, 2018 – Announcing the Release of Barman v2.4
  • May 17, 2018 – OmniDB 2.8 Available – Now with Support for 3rd Generation Postgres-BDR
  • May 10, 2018 – Announcing The Release of 2UDA for PostgreSQL 10.4, 9.6.9, 9.5.13
  • May 3, 2018 – Announcing The Release of repmgr 4.0.5
  • April 19, 2018 – 2ndQuadrant announces 3rd generation of Postgres-BDR
  • April 12, 2018 – OmniDB 2.7 Released – Now with improved security and debugging features
  • March 20, 2018 – Announcing the Release of pglogical 2.2
  • March 16, 2018 – Announcing the Release of BDR 1.0.5
  • March 15, 2018 – Announcing the Release of OmniDB 2.6
  • March 9, 2018 – Announcing the Release of repmgr 4.0.4
  • March 1, 2018 – Announcing the Release of 2UDA for PostgreSQL 10.3, 9.6.8, and 9.5.12
  • February 15, 2018 – Announcing the Release of repmgr 4.0.3
  • February 12, 2018 – OmniDB 2.5 Released – Now with Support for Oracle Databases
  • January 18, 2018 – Announcing the Release of repmgr 4.0.2
  • January 16, 2018 – Announcing the Release of OmniDB 2.4.1
  • January 11, 2018 – Announcing the Release of pglogical 2.1.1
  • December 13, 2017 – Announcing the Release of repmgr 4.0.1
  • December 7, 2017 – Announcing The Release Of OmniDB 2.4
  • December 5, 2017 – PostgreSQL webinar covering JSON Data Types announced by 2ndQuadrant
  • November 29, 2017 – 2ndQuadrant enlisted by internationally recognized polar and marine research institute
  • November 22, 2017 – Announcing the Release of Postgres-BDR 9.4.15
  • November 21, 2017 – 2ndQuadrant Announces the Release of repmgr 4.0
  • November 10, 2017 – Announcing The Release of 2UDA for PostgreSQL 10.1, 9.6.6, and 9.5.10
  • November 2, 2017 – Announcing the Release of OmniDB 2.3
  • October 30, 2017 – Announcing the Release of BDR 1.0.3
  • October 19, 2017 – 2ndQuadrant CEO Simon Riggs to give keynote at PGConf.EU
  • October 12, 2017 – Announcing the Release of OmniDB 2.2
  • October 11, 2017 – Announcing the Release of repmgr v4.0 Beta
  • October 10, 2017 – 2ndQuadrant CEO Simon Riggs to Speak at PGDay.IT
  • October 9, 2017 – 2ndQuadrant Announces the Release of pglogical 2.1
  • October 9, 2017 – Announcing the Release of 2UDA for PostrgreSQL 10
  • October 5, 2017 – 2ndQuadrant contributes major features to PostgreSQL 10
  • September 28, 2017 – Schedule for 2ndQuadrant PostgreSQL Conference 2017 Announced
  • September 21, 2017 – Announcing The Release of 2UDA for PostgreSQL 10 RC1
  • September 12, 2017 – Announcing the Release of OmniDB 2.1
  • September 5, 2017 – Announcing the Release of Barman v2.3
  • August 31, 2017 – 2ndQuadrant Achieves Best-in-Class Net Promoter Score
  • August 28, 2017 – Announcing The Release of Postgres-XL 9.5r1.6
  • August 25, 2017 – Announcing The Release of BDR 9.4.13
  • August 22, 2017 – 2ndQuadrant Announces the Release of OmniDB
  • August 10, 2017 – Announcing Release of 2UDA 9.5.8, 9.6.4 and PostgreSQL 10 Beta 3
  • July 27, 2017 – Announcing 2ndQuadrant PostgreSQL Conference 2017
  • July 17, 2017 – Announcing the Release of Barman 2.2
  • July 14, 2017 – Case study – Global Award winning digital studio chooses BDR!
  • July 13, 2017 – Announcing The Release of 2UDA Beta 2 for PostgreSQL 10
  • July 12, 2017 – Announcing the release of BDR 2.0
  • July 5, 2017 – Announcing the Release of Postgres-XL 10 alpha
  • June 8, 2017 – Announcing the release of repmgr 3.3.2
  • June 7, 2017 – Announcing the release of pglogical 2.0.1
  • May 4, 2017 – Announcing the Release of pglogical 2.0
  • May 18, 2017 – Announcing the release of 2UDA version 10 Beta 1
  • May 18, 2017 – Announcing the release of BDR 9.4.12
  • May 11, 2017 – Announcing the release of 2UDA 9.6.3 and 9.5.7
  • April 28, 2017 – Book release! PostgreSQL 9 Administration Cookbook – Third Edition
  • April 27, 2017 – Announcing the release of 2ndQPostgres
  • April 20, 2017 – Announcing the Release of Postgres-XL 9.5r1.5
  • March 24, 2017 – Announcing The Release of Postgres-BDR 9.4
  • March 23, 2017 – Announcing The Release Of repmgr 3.3.1
  • February 9, 2017 – Announcing The Release of 2UDA 9.6.2 and 9.6.5
  • January 11, 2017 – New Service Launched – PostgreSQL Security Audit
  • January 6, 2017 – Announcing The Release Of repmgr 3.3
  • January 5, 2017 – Barman v2.1 Announced
  • January 4, 2017 – Announcing The Release Of pglogical 1.2.2
  • Announcing the Release of OmniDB 2.14
  • Announcing the Release of Barman v2.7
  • Announcing the release of repmgr 4.3
  • OmniDB 2.7 released – Now with improved security and debugging features
  • Announcing the Release of OmniDB 2.15
  • Announcing Postgres Installer with New Updates
  • Announcing the Release of Barman v2.8
  • 2ndQuadrant listed amongst the 20 Most Promising IBM Solution Providers 2019
  • Announcing Postgres Installer for PostgreSQL 12 Beta 1
  • Announcing the Release of OmniDB 2.16
  • Announcing Postgres Installer with New Security Updates
  • Announcing the release of repmgr 4.4
  • July 25, 2019 – Announcing the Release of pglogical 2.2.2
  • 2ndQuadrant partners with Thales using BDR for advanced Data Security application
  • August 1, 2019 – Announcing the Release of Barman v2.9
  • Announcing Postgres Installer with New Security and Feature Updates
  • October 3, 2019 – 2ndQuadrant contributes major features to PostgreSQL 12
  • repmgr 5.0 released: Now with support for PostgreSQL 12
  • December 5, 2019 – Announcing the Release of Barman v2.10
  • OmniDB 2.17 Available – Now with Support for PostgreSQL 12
  • 2ndQuadrant Becomes 1st Kubernetes Certified Service Provider (KCSP) for PostgreSQL
• Events
• Case Studies
  • tastyworks Case Study Download
  • Telefónica del Sur Case Study Form
  • Animal Logic Case Study Form
  • Alfred Wegener Institute Case Study Form
  • Navionics Case Study Form
  • Met Office Case Study Form
  • Agilis Systems Case Study Form
  • London & Partners Case Study Form
  • Healthcare Software Solutions Case Study Form
  • Performance Tuning
    • tastyworks
  • Multi-Master Clusters
    • Telefónica del Sur
    • Animal Logic
  • Database Administration
    • Agilis Systems
  • Professional Training
    • Met Office
    • London & Partners
  • Database Upgrades
    • Alfred Wegener Institute (AWI)
  • Database Migration
    • Navionics
    • Healthcare Software Solutions (HSS)
• Careers
• Team Profile
• Books
  • PostgreSQL 10 Administration Cookbook
  • PostgreSQL High Availability Cookbook – Second Edition
  • PostgreSQL 9 Administration Cookbook – 3rd Edition
  • PostgreSQL Server Programming Cookbook – 2nd Edition
  • PostgreSQL 9 Cookbook : Chinese Edition
  • PostgreSQL 11 Administration Cookbook
• Introducing PostgreSQL
  • PostgreSQL – History
  • 2ndQuadrant’s Passion for PostgreSQL
    • Contributions to PostgreSQL 11
    • Contributions to PostgreSQL 10
    • Contributions to PostgreSQL 9.6
    • Contributions to PostgreSQL 12
  • Who uses PostgreSQL?
  • PostgreSQL FAQ
  • PostgreSQL vs MySQL
  • Business Case for PostgreSQL
  • PostgreSQL Blog Listing
  • Security Information
• Training
  • Training Catalog and Scheduled Courses
  • PostgreSQL Training Chicago
  • Advanced Development & Performance
    • Advanced Development & Performance Class
  • Linux for PostgreSQL DBAs
  • BDR
  • PostgreSQL Database Administration
  • PostgreSQL Data Warehousing & Partitioning
  • PostgreSQL for Developers
  • PostgreSQL Immersion
  • PostgreSQL Immersion for Cloud Databases
  • PostgreSQL Security
  • Postgres-XL-10
  • Practical SQL
  • Replication, Backup & Disaster Recovery
    • Replication, Backup and Disaster Recovery Class
  • PostgreSQL Training London
  • Courses
    • Classes
      • PostgreSQL Database Administration Class
      • PostgreSQL Immersion Class
      • Advanced Development & Performance 30 Sep. 2019
      • Replication, Backup & Disaster Recovery 18 Nov. 2019
    • Replication, Backup and Disaster Recovery
  • Introduction to PostgreSQL and Kubernetes
• Contact Us
• Professional PostgreSQL
• Postgres Learning Center
• Ask Simon
• Whitepapers
• Sitemap
• Videos
• Migrazione da Oracle®

Posts

• Posts

2ndQuadrant

• Performance limits of logical replication solutions
• Postgres-XL 9.5R1Beta1 is here!
• Tables and indexes vs. HDD and SSD
• Planning to succeed
• Keen on Kanban? The 5432…MeetUs! Conference can teach you everything you need to know!
• Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6
• Back to the Future Part 3: pg_rewind with PostgreSQL 9.6
• Load data in Postgres-XL at over 9M rows/sec
• Highlights of PGconf.EU
• On the impact of full-page writes
• Avoiding Disasters in New York
• CHAR(16) Scalability for Business
• CHAR16 Conf Panel Video
• PGDay.IT 2016 in Prato, Italy
• PostgreSQL’s Popularity Goes Up Again
• What does pg_start_backup() do?
• Using Java Database Interface (jDBI) with PostgreSQL
• Using Java ORMs with PostgreSQL – MyBatis
• Using EclipseLink with PostgreSQL
• Explaining CREATE INDEX CONCURRENTLY
• Dataloss at GitLab
• Autovacuum Tuning Basics
• PGConf India 2017 – An Event to Remember
• PgDay Paris 2017
• 2ndQuadrant – Not the Gartner Magic Quadrant
• In the defense of sar (and how to configure it)
• “Now is Better Than Never” – Why I decided to attend PyCon8…
• What’s new in Postgres-XL 9.6
• News and Roadmap for BDR (Multi-master PostgreSQL)
• News and Roadmap from Postgres-XL 10
• Oracle High Availability concepts in PostgreSQL
• pgxc_ctl: Teaching Postgres-XL in New York City
• PostgreSQL Meltdown Benchmarks
• PostgreSQL Developer Meeting Brussels
• PostgreSQL 11 – Server-side Procedures (Part 2)
• PostgreSQL – The most loved RDBMS
• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
• Prague PostgreSQL Meetup
• PGConf APAC 2018 – bigger & better each year
• Don’t be hard-headed… Harden your PostgreSQL database to ensure security
• OmniDB: Console Tab
• Partition Elimination in PostgreSQL 11
• 2ndQuadrant at PostgresConf US 2018
• Introduction to Postgres-BDR [Webinar Follow-up]
• Postgres Installer – A GUI based, user-friendly installer for PostgreSQL
• Data Modelling – It’s a lot more than just a diagram
• Scaling IoT Time Series Data with Postgres-BDR
• Postgres Installer – A Step by Step Guide to install PostgreSQL
• Postgres Installer by 2ndQuadrant – now supports OmniDB!
• Upgrading to PostgreSQL 11 with Logical Replication
• Adding new table columns with default values in PostgreSQL 11
• PostgreSQL 11: Partitioning Evolution from Postgres 9.6 to 11
• PG Phriday: Studying Stored Procedures in Postgres 11
• PGDay Down Under 2018
• Webinar: PostgreSQL is NOT your traditional SQL database [Follow Up]
• Sequential UUID Generators
• Databases vs. encryption
• Webinar : Introduction to OmniDB [Follow Up]
• Sequential UUID Generators on SSD
• PostgreSQL 9.3 EOL – Why is it Important to Upgrade?
• Webinar: pglogical and Postgres-BDR Update [Follow Up]
• CHAR (16) – Another conference on the horizon but with a focus on business
• Working towards Postgres-XL 9.5
• Tablesample and Other Methods for Getting Random Tuples
• Ansible Loves PostgreSQL
• PostgreSQL Planet in Ansible Galaxy
• Benchmarking Postgres-XL
• Performance of Sequences and Serials in Postgres-XL
• PgBouncer 1.7 – “Colors Vary After Resurrection”
• Postgres-XL: Dealing with read-only transactions
• Prague PostgreSQL Developer Day 2016
• FLOSS UK Spring Conference
• Are we ready for Nordic PGDay?
• pgpredict – Predictive analytics in PostgreSQL
• Postgres-XL 9.5r1 has finally arrived!
• On the usefulness of expression indexes
• Column Store Plans
• Postgres-XL 9.5r1.1 released
• PGLogical 1.1 packages for PostgreSQL 9.6beta1
• Auditing Users and Roles in PostgreSQL
• Application users vs. Row Level Security
• 5432…MeetUs! Conference Gives Opportunities for Meaningful Takeaways
• Second Edition of 5432…MeetUs!
• Conference isn’t enough?! Join us for post-conference training!
• Finding your PostgreSQL version
• Evolution of Fault Tolerance in PostgreSQL
• Evolution of Fault Tolerance in PostgreSQL: Replication Phase
• On the benefits of sorted paths
• Working Together to create an Open Source World
• PostgreSQL vs. Linux kernel versions
• Evolution of Fault Tolerance in PostgreSQL: Time Travel
• Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit
• PostgreSQL 10 Roadmap
• Thoughts on Uber’s List of Postgres Limitations
• PostgreSQL Solutions Roadmap
• PostgreSQL 9.1 End of Life
• When to use Postgres-BDR or Postgres-XL?
• Postgres-BDR: 2 Years in Production
• Back to the Future Pt. 1: Introduction to pg_rewind
• Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5
• The Best Barman Ever
• The PostgreSQL 9.6 release is almost here!
• Basics of Tuning Checkpoints
• PostgreSQL Solution Architecture
• When autovacuum does not vacuum
• How long does it take to change your mind?
• Webinar : Ansible & PostgreSQL [Follow Up]
• Postgres-XL and global MVCC
• Webinar: Migration to PostgreSQL [Follow up]
• Generated columns in PostgreSQL 12
• Partitioning enhancements in PostgreSQL 12
• PostgreSQL 12: Partitioning is now faster
• PostgreSQL 12: A Few Special-Case Performance Enhancements
• Webinar: New Features in Postgres 12 [Follow up]
• PostgreSQL 12: Foreign Keys and Partitioned Tables
• Managing another PostgreSQL Commitfest
• Postgres-BDR: It is also about fast safe upgrades
• Webinar: PostgreSQL Partitioning [Follow up]
• PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes
• Webinar: Using SSL with PostgreSQL and pgbouncer [Follow Up]
• Setting SSL/TLS protocol versions with PostgreSQL 12

Alvaro's PlanetPostgreSQL

• XMLTABLE in PostgreSQL
• Talk slides: Partitioning Improvements in PostgreSQL 11
• Partitioning Improvements in PostgreSQL 11
• PostgreSQL 11: Patch Reviewers for Partitioning Patches
• Managing a PostgreSQL Commitfest
• Code coverage stats
• 9.6 Scariest Patch Tournament
• Column Store Plans
• PostgreSQL 12: Foreign Keys and Partitioned Tables
• Managing another PostgreSQL Commitfest

Andrea's Planet PostgreSQL

• PGDay Down Under 2018

Andrew's PlanetPostgreSQL

• Managed Database Services – pros and cons
• The rds_superuser role isn’t that super
• Problem with Buildfarm registrations fixed
• JSON version of XMLTABLE example
• Support for enums in btree_gin and btree_gist
• BuildFarm client release 4.19
• Out of tree builds
• Up to date access to postgres logs
• Announcing Release 5 of the PostgreSQL Buildfarm Client
• Setting up a build machine for Visual Studio 2017
• Announcing Release 6 of PostgreSQL Buildfarm client
• Buildfarm Client Bugfix Release 6.1
• PostgreSQL Buildfarm Client Release 8
• Road test your patch in one command
• Keeping our perl code clean
• [Video] Introduction to JSON data types in PostgreSQL
• Managing Freezing in PostgreSQL
• Adding new table columns with default values in PostgreSQL 11
• PostgreSQL Buildfarm Client Release 9
• Where and when you need a root.crt file
• PostgreSQL Buildfarm Client Release 10
• Buildfarm RSS feed
• Release 11 of the PostgreSQL Buildfarm client
• jsonb_set_lax

Anna's PlanetPostgreSQL

• Barman 2.10 – Recovery of partial WAL files

Barman

• Barman 1.1.0
• Released Barman 1.1.1
• Barman 1.1.1 packages available for Ubuntu 12.04 (Precise Pangolin)
• Announcing Barman 1.3.0
• Announcing Barman 1.3.1
• Announcing Barman 1.3.3
• Announcing Barman 1.5.0
• Announcing Barman 1.6.0
• Oracle High Availability concepts in PostgreSQL
• Managing the backup of several PostgreSQL servers with Barman
• Barman 1.1.2 released
• Retention of backups with Barman
• Configuring retention policies in Barman
• Announcing Barman 1.2.1
• Announcing Barman 1.2.3
• Detecting smelly backups with Barman
• What’s new about Barman 1.4.0?
• Automating Barman with Puppet: it2ndq/barman (part one)
• Automating Barman with Puppet: it2ndq/barman (part two)
• Getting WAL files from Barman with ‘get-wal’
• Announcing Barman 1.5.1
• Barman 1.6.1 is Released

Bilal's PlanetPostgreSQL

• Webinar: BDR – Latest Features & Updates [Follow Up]

Britt's Marketing

• PostgreSQL and the Platinum Guarantee
• Don’t be hard-headed… Harden your PostgreSQL database to ensure security

Britt's PlanetPostgreSQL

• “Now is Better Than Never” – Why I decided to attend PyCon8…
• Barman 1.6.1 is Released
• 5432…MeetUs! Conference Gives Opportunities for Meaningful Takeaways
• Second Edition of 5432…MeetUs!

Cedric's FR PlanetePostgreSQL

• pgDay 2017 à Paris: conférence PostgreSQL internationale
• pgFincore 1.2, une extension PostgreSQL

Christian's PlanetPostgreSQL

• Announcing repmgr 2.0RC2
• Announcing repmgr 2.0
• Announcing repmgr 2.0RC1

Craig's PlanetPostgreSQL

• How do PostgreSQL security_barrier views work?
• Row security in PostgreSQL – Overview
• PostgreSQL anti-patterns: read-modify-write cycles
• How to find out which PostgreSQL table a file on disk corresponds to
• BDR History and future
• Re-import repository keys for BDR and pglogical apt repositories
• Traceable commit for PostgreSQL 10
• Using the PostgreSQL TAP framework in extensions
• Plan for the unexpected: install diagnostic tools on your PostgreSQL servers
• Using Multimaster and BDR appropriately – LinuxConfAu
• Dev Corner: error context stack corruption
• Improving PostgreSQL performance on AWS EC2
• During installation, cluster initialisation fails with the message “No error” on Windows
• Simplifying compilation of PostgreSQL on Windows
• PostgreSQL regression tests hanging on Windows? Check path depth.
• Testers needed for proposed 9.3 SEPostgreSQL enhancements
• Cygwin users needed to test a patch for PostgreSQL 9.3
• Help us make a better PostgreSQL 9.3!
• Choosing a PostgreSQL text search method
• Testing new PostgreSQL versions without messing up your existing install
• Tracing PostgreSQL with perf
• PostgreSQL guts: What is “resjunk”?
• Compiling PostgreSQL extensions with Visual Studio on Windows
• Streaming replication slots in PostgreSQL 9.4
• Putting a PostgreSQL tablespace on a ramdisk risks ALL your data
• PostgreSQL’s CTEs are optimisation fences
• Announcing BDR RPMs for 9.4
• pg_sysdatetime: a simple cross-platform PostgreSQL extension
• Compiling and debugging PostgreSQL’s PgJDBC under Eclipse
• Ware Yosemite? Possible PostgreSQL upgrade issues in OS X 10.10
• All-processes breakpoints / watchpoints for PostgreSQL
• BDR for PostgreSQL: Present and future
• Dynamic SQL-level configuration for BDR 0.9.0
• PostgreSQL anti-patterns: Unnecessary json/hstore dynamic columns
• BDR 0.9.2 and BDR-PostgreSQL 9.4.4 released
• When are we going to contribute BDR to PostgreSQL?
• Emulating row security in PostgreSQL 9.4
• Failover slots for PostgreSQL
• LVM: “Unable to create a snapshot smaller than 2 chunks”
• What is SKIP LOCKED for in PostgreSQL 9.5?
• Don’t set fsync=off if you want to keep your data
• Visual PostgreSQL debugging
• PostgreSQL-based application performance: latency and hidden delays
• How to check the lock level taken by operations in PostgreSQL
• BDR 1.0
• BDR is coming to PostgreSQL 9.6
• Transaction traceability in PostgreSQL 10 with txid_status(…)
• Using Docker Hub PostgreSQL images
• Developing on many versions of PostgreSQL at once
• A convenient way to launch psql against postgres while running pg_regress

Data Mining

• Association rules with MADlib in Greenplum
• 2UDA – New features in Orange (Part 2)
• 2UDA RC1 – New features in Orange (Part 1)
• pgpredict – Predictive analytics in PostgreSQL

David's PlanetPostgreSQL

• Parallel Aggregate – Getting the most out of your CPUs
• Partition Elimination in PostgreSQL 11
• PostgreSQL 11: Partitioning Evolution from Postgres 9.6 to 11
• The PostgreSQL 9.6 release is almost here!
• Benchmark on a Parallel Processing Monster!
• PostgreSQL 12: Partitioning is now faster

DevOps

• Kanban & devops culture at 2ndQuadrant – Part 1
• Kanban & devops culture at 2ndQuadrant – Part 2
• Kanban & devops culture at 2ndQuadrant – Part 3
• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)

Eisentraut's PlanetPostgreSQL

• More robust collations with ICU support in PostgreSQL 10
• PostgreSQL 10 identity columns explained
• Upgrading to PostgreSQL 11 with Logical Replication
• Maintaining feature branches and submitting patches with Git
• PostgreSQL with passphrase-protected SSL keys under systemd
• Setting SSL/TLS protocol versions with PostgreSQL 12

El Planeta PostgreSQL de Jaime

• Indexando ando: Índices GIN
• VACUUM FREEZE y el misterio de relfrozenxid

Elein’s PlanetPostgreSQL

• JOIN LATERAL
• Having Group By Clauses — elein’s GeneralBits
• Swoop de Dupe
• Beautiful things, strings.
• Postgresql Interval, Date, Timestamp and Time Data Types

Featured

• And Barman 1.6.0 is out!
• Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6
• More ‘POWER’ for PostgreSQL
• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
• Prague PostgreSQL Meetup
• CHAR (16) – Another conference on the horizon but with a focus on business
• The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4
• Tablesample In PostgreSQL 9.5
• Ansible Loves PostgreSQL
• Benchmarking Postgres-XL
• Redislog: Integrating PostgreSQL with Logstash for devops real-time monitoring
• JSONB and PostgreSQL 9.5: with even more powerful tools!
• Concurrent backups with Barman and PostgreSQL 9.6
• Evolution of Fault Tolerance in PostgreSQL
• Evolution of Fault Tolerance in PostgreSQL: Replication Phase
• PostgreSQL 9.6: Parallel Sequential Scan
• On the benefits of sorted paths
• Report from DatabaseCamp, NYC
• PostgreSQL vs. Linux kernel versions
• Evolution of Fault Tolerance in PostgreSQL: Time Travel
• Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit
• Speed up getting WAL files from Barman
• Back to the Future Pt. 1: Introduction to pg_rewind
• Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5
• The Best Barman Ever

Florins PlanetPostgreSQL

• Support for PostgreSQL’s System identifier in Barman

Francesco's PlanetPostgreSQL

• PostgreSQL 9.4 for administrators (part one)
• PostgreSQL 9.4 for administrators (part two)
• Automating Barman with Puppet: it2ndq/barman (part one)
• Automating Barman with Puppet: it2ndq/barman (part two)
• Automating Barman with Puppet: it2ndq/barman (part three)
• PostgreSQL 9.6: Parallel Sequential Scan

Gabriele's PlanetPostgreSQL

• Installing Greenplum Single Node Edition on Amazon’s EC2
• How to install multiple PostgreSQL servers on RedHat Linux
• Early bird registrations open for PGDay.IT 2011
• Call for papers for PGDay.IT 2011 has been extended
• PGDay.IT 2011 was “bellissimo”!
• Barman is finally out
• Management of the WAL archive in Barman
• Submit your talk for PGDay.IT
• PostgreSQL 9.3 development: Array ELEMENT Foreign Keys
• The “French Revolution”
• Call for papers for PGDay.IT has been extended
• Barman explained in a 83 seconds spot
• More ‘POWER’ for PostgreSQL
• PostgreSQL Meetup in Melbourne, Australia
• Kanban & devops culture at 2ndQuadrant – Part 3
• Barman 2.2 and the magic of parallel copy
• The Barman is ready for PostgreSQL 10
• Australia: Last seats for our PostgreSQL courses in Melbourne
• My “top 5” for PGConf.eu in Prague
• 79 real attendees at the Italian PGDay
• Managing the backup of several PostgreSQL servers with Barman
• It’s a long way to Melbourne if you want to rock ‘n’ roll with Postgres!
• Retention of backups with Barman
• The first Australian PostgreSQL Day
• Configuring retention policies in Barman
• How to safely change the “postgres” user password via “psql”
• OSS4B 2013, innovate through Open Source
• Postgres and devops: testing 9.3 with Vagrant and Puppet – part one
• Postgres and devops: testing 9.3 with Vagrant and Puppet – part two
• Managing PostgreSQL in a devops environment
• Detecting smelly backups with Barman
• Italian PGDay, eighth edition: over 120 attendees!
• How monitoring of WAL archiving improves with PostgreSQL 9.4 and pg_stat_archiver
• Incremental backup with Barman 1.4.0
• Getting WAL files from Barman with ‘get-wal’
• Redislog: Integrating PostgreSQL with Logstash for devops real-time monitoring
• Waiting for Barman 1.6.1
• Concurrent backups with Barman and PostgreSQL 9.6
• Speed up getting WAL files from Barman
• The Best Barman Ever
• Geo-redundancy of PostgreSQL database backups with Barman

Gianni's PlanetPostgreSQL

• Some ideas about low-level resource pooling in PostgreSQL
• pgChess code published
• CTE and the Birthday Paradox
• PostgreSQL User Group NL

Giulio's PlanetPostgreSQL

• Barman 2.1 and the new –archive option
• What’s new about Barman 1.4.0?
• PostgreSQL 9.5: IMPORT FOREIGN SCHEMA
• 2ndQuadrant speaks at PostgreSQL sessions

Giuseppe's PlanetPostgreSQL

• BRIN for PostGIS: my story at the Code Sprint 2016 in Paris
• Back to the Future Part 3: pg_rewind with PostgreSQL 9.6
• The CHECK clause for updatable views
• NoSQL with PostgreSQL 9.4 and JSONB
• The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4
• Back to the Future Pt. 1: Introduction to pg_rewind
• Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5

Greenplum

• Installing Greenplum Single Node Edition on Amazon’s EC2
• Installing PostGIS on Greenplum Single Node Edition
• Installing Greenplum Single Node Edition on Ubuntu 10.4 (Lucid)
• Performing parallel ETL with Greenplum’s gpfdist and external tables
• How to test Greenplum Community Edition on VirtualBox
• Association rules with MADlib in Greenplum
• ETL with Talend and Greenplum – Part one: connections
• Using PL/Java in Greenplum
• ETL with Talend and Greenplum – Part two: data import
• Using dblink in Greenplum
• ETL with Kettle and Greenplum – Part one: setting up your job.
• Using gpmigrator in Greenplum 4.1.1
• ETL with Kettle and Greenplum – Part Two: importing data
• Mapreduce in Greenplum 4.1
• Performing ETL using Kettle with GPFDIST and GPLOAD
• Mapreduce in Greenplum 4.1 – 2nd part
• Using Greenplum 4.1 in Ubuntu 11.10
• A Greenplum 4.1 installation handbook
• How to initialize Greenplum on multiple nodes
• Greenplum 4.2 is out!
• Setting JDBC with Greenplum
• External web tables in Greenplum
• Greenplum CE 4.2 XML support
• How to test Greenplum Community Edition 4.2.1 on VirtualBox
• How to install fuzzystrmatch on Greenplum Community Edition

Greg's PlanetPostgreSQL

• Trade-offs in Hot Standby Deployments
• PGEast, Hardware Benchmarking, and the PG Performance Farm
• AMD, Intel, and PostgreSQL
• The Return of XFS on Linux
• PostgreSQL, FreeBSD, and Free Dog Food
• Heads in the cloud at CHAR(10)
• PostgreSQL Performance and PGWest
• “PostgreSQL 9.0 High Performance” book is out
• PG West talks
• PostgreSQL CommitFest #3 for 9.1 needs you!
• Easier PostgreSQL 9.0 clusters with repmgr
• How not to build PostgreSQL 9.0 extensions on RPM platforms
• Tuning Linux for low PostgreSQL latency
• Hinting at PostgreSQL
• Data generation and hardware quality
• Spring 2011 PostgreSQL Conferences, US/Canada
• PostGIS In Action
• The cost of free PostgreSQL publicity
• Planetary alignment
• Measuring PostgreSQL Checkpoint Statistics
• Telling Your Users to Go Fork Themselves
• Updates to PostgreSQL testing tools with benchmark archive
• Reducing the postgresql.conf, parameter at a time
• Linux filesystems and PostgreSQL checkpoint benchmarks
• Intel SSD, now off the sh..err, shamed list

Gulcin's PlanetPostgreSQL

• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
• Prague PostgreSQL Meetup
• Tablesample In PostgreSQL 9.5
• What’s New in PgBouncer 1.6
• Tablesample and Other Methods for Getting Random Tuples
• Ansible Loves PostgreSQL
• PostgreSQL Planet in Ansible Galaxy
• PgBouncer 1.7 – “Colors Vary After Resurrection”
• Prague PostgreSQL Developer Day 2016
• FLOSS UK Spring Conference
• Are we ready for Nordic PGDay?
• Evolution of Fault Tolerance in PostgreSQL
• Evolution of Fault Tolerance in PostgreSQL: Replication Phase
• Evolution of Fault Tolerance in PostgreSQL: Time Travel
• Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit

Haroon's PlanetPostgreSQL

• PostgreSQL Time-based Partitioning for IoT Data using pg_partman
• PostgreSQL 10 easy installation with 2UDA
• Using Window Functions for Time Series IoT Analytics in Postgres-BDR
• Scaling IoT Time Series Data with Postgres-BDR
• PostgreSQL and IoT Data Localization, Integration, and Write Scalability
• PostgreSQL for IoT Data Retention and Archiving
• PostgreSQL: Regular expressions and pattern matching

Howard Postgres Marketing World

• CHAR (16) – Another conference on the horizon but with a focus on business

Howard's PlanetPostgreSQL

• Enterprise Support – The final hurdle for PostgreSQL?
• CHAR (16) – Another conference on the horizon but with a focus on business

Ian's PlanetPostgreSQL

• repmgr 3.2 is here with Barman support and Brand New High Availability features
• repmgr 3.3
• Japan PostgreSQL Conference 2014
• Letter from Japan
• Improvements in repmgr 3.1.4
• Replication configuration changes in PostgreSQL 12

International News

• Hot Standby User Group (online) – 13 Jan at 1600UTC
• 2ndQuadrant US Launch Party – February 12 New York City – Canceled
• Heads in the cloud at CHAR(10)
• “PostgreSQL 9.0 High Performance” book is out
• Easier PostgreSQL 9.0 clusters with repmgr
• PostgreSQL training for MySQLers
• 2ndQuadrant Deutschland – Special Training Opening Bargain
• PostgreSQL agent in SQL Standard committee again
• EuroPython 2011: “The Python and the Elephant”
• Soon! 4-Days Admin Training in German
• Announcing Barman 1.3.0
• Announcing Barman 1.3.1
• Announcing Barman 1.3.3
• Announcing Barman 1.5.0
• Announcing Barman 1.6.0
• Extended the call for papers for “5432…MeetUs!”
• PostgreSQL User Group NL
• Keen on Kanban? The 5432…MeetUs! Conference can teach you everything you need to know!
• Prague PostgreSQL Meetup
• Australia: Last seats for our PostgreSQL courses in Melbourne
• Announcing Barman 1.0, Backup and Recovery Manager for PostgreSQL
• Barman 1.1.2 released
• Announcing Barman 1.2.1
• Announcing Barman 1.2.3
• Announcing Barman 1.5.1
• Barman 1.6.1 is Released
• 5432…MeetUs! Conference Gives Opportunities for Meaningful Takeaways
• Second Edition of 5432…MeetUs!
• Conference isn’t enough?! Join us for post-conference training!

Internet of Things

• PostgreSQL Time-based Partitioning for IoT Data using pg_partman
• Using Window Functions for Time Series IoT Analytics in Postgres-BDR
• Scaling IoT Time Series Data with Postgres-BDR
• PostgreSQL and IoT Data Localization, Integration, and Write Scalability
• PostgreSQL for IoT Data Retention and Archiving

Jaime's PlanetPostgreSQL

• Managing useful clusters with repmgr

John’s PlanetPostgreSQL

• Optimizing storage of small tables in PostgreSQL 12
• PostgreSQL 12: A Few Special-Case Performance Enhancements

Jonathan's PlanetPostgreSQL

• PGDay.IT 2016 in Prato, Italy

Josette's PlanetPostgreSQL

• … and now for something completely different!

Kirk’s PlanetPostgreSQL

• Generated columns in PostgreSQL 12
• Partitioning enhancements in PostgreSQL 12
• PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes

Koichi’s PlanetPostgreSQL

• Postgres-XL and global MVCC

Lan's PlanetPostgreSQL

• pgpredict – Predictive analytics in PostgreSQL

Liaqat's PlanetPostgreSQL

• Here’s How You Can Run OmniDB On Postgres10 [VIDEO]
• Webinar: Introduction to JSON data types in PostgreSQL [Follow Up]
• Webinar: Data Integration With PostgreSQL [Follow Up]
• Power of Indexing in PostgreSQL [Webinar Follow-up]
• Introduction to Postgres-BDR [Webinar Follow-up]
• Postgres Installer – A GUI based, user-friendly installer for PostgreSQL
• Postgres Installer – A Step by Step Guide to install PostgreSQL
• Webinar : Database Security in PostgreSQL [Follow Up]
• Webinar : New Features in PostgreSQL 11 [Follow Up]
• Webinar: PostgreSQL is NOT your traditional SQL database [Follow Up]
• Webinar : Introduction to OmniDB [Follow Up]
• PostgreSQL 9.3 EOL – Why is it Important to Upgrade?
• Webinar: pglogical and Postgres-BDR Update [Follow Up]
• Webinar: Banking on Postgres – Financial Application Considerations [Follow up]
• Webinar : Ansible & PostgreSQL [Follow Up]
• Webinar: Achieving High Availability with PostgreSQL [Follow Up]
• Webinar: Postgres Vacuuming Through Pictures [Follow up]

Marco's PlanetPostgreSQL

• JSONB type performance in PostgreSQL 9.4

Mark's PlanetPostgreSQL

• Loading Tables and Creating B-tree and Block Range Indexes
• Index Overhead on a Growing Table
• SCALE 14x
• Visualizing sar data
• Testing Postgres-XL with DBT-3
• PostgreSQL Award
• Adventure in programming languages and simple statistics

Marriya's PlanetPostgreSQL

• Postgres Installer by 2ndQuadrant – now supports OmniDB!

Nouman's PlanetPostgreSQL

• Webinar: You forgot to put the WHERE in DELETE? [Follow Up]

OmniDB

• OmniDB: Average execution time of PostgreSQL webmethods
• PostgreSQL 10 Logical Replication with OmniDB
• Postgres-BDR with OmniDB
• Postgres-XL with OmniDB
• pglogical with OmniDB
• OmniDB – Now with PL/pgSQL debugger!
• Here’s How You Can Run OmniDB On Postgres10 [VIDEO]
• OmniDB: Monitoring Dashboard
• Oracle with OmniDB
• OmniDB: Console Tab
• Postgres-BDR 3.0 with OmniDB
• Postgres Installer by 2ndQuadrant – now supports OmniDB!
• OmniDB debugger for PostgreSQL 11
• Webinar : Introduction to OmniDB [Follow Up]

Pallavi's PlanetPostgreSQL

• How Postgres-XL is tested

Pavan's PlanetPostgreSQL

• Postgres-XL 9.5R1Beta1 is here!
• Sharding: Bringing back Postgres-XL technology into core PostgreSQL
• How will Postgres-XL exploit the Parallel Query Capabilities of PostgreSQL 9.6?
• Load data in Postgres-XL at over 9M rows/sec
• Postgres-XL Scalability for Loading Data
• Explaining CREATE INDEX CONCURRENTLY
• Corruption in CREATE INDEX CONCURRENTLY
• Looking forward to PGConf India 2017
• PGConf India 2017 – An Event to Remember
• News and Roadmap from Postgres-XL 10
• [Video] Power of Indexing in PostgreSQL
• Working towards Postgres-XL 9.5
• Benchmarking Postgres-XL
• Performance of Sequences and Serials in Postgres-XL
• Postgres-XL: Dealing with read-only transactions
• Looking forward to PGDay India 2016
• Postgres-XL 9.5R1Beta2 Released!
• Postgres-XL 9.5r1 has finally arrived!
• Postgres-XL 9.5r1.1 released

Petr's PlanetPostgreSQL

• Logical Replication in PostgreSQL 10
• pglogical 2.1 and Logical Replication in PostgreSQL 10
• Progress on online upgrade
• PGLogical 1.1 released with sequence support and more
• PGLogical 1.1 packages for PostgreSQL 9.6beta1
• pglogical 1.2 with PostgreSQL 9.6 support

pglogical

• The process that created pglogical
• Performance limits of logical replication solutions
• PG Phriday: pglogical and Postgres 10 Partitions
• pglogical with OmniDB
• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
• Why Logical Replication?
• On pglogical performance
• FLOSS UK Spring Conference
• PGLogical 1.1 released with sequence support and more
• PGLogical 1.1 packages for PostgreSQL 9.6beta1
• Untangling the PostgreSQL upgrade

Postgres Installer

• Postgres Installer – A GUI based, user-friendly installer for PostgreSQL
• Postgres Installer – A Step by Step Guide to install PostgreSQL
• Postgres Installer by 2ndQuadrant – now supports OmniDB!

Postgres-XL

• Postgres-XL and global MVCC

PostgreSQL

• Trade-offs in Hot Standby Deployments
• PGEast, Hardware Benchmarking, and the PG Performance Farm
• AMD, Intel, and PostgreSQL
• The Return of XFS on Linux
• How to install multiple PostgreSQL servers on RedHat Linux
• PostgreSQL, FreeBSD, and Free Dog Food
• Some ideas about low-level resource pooling in PostgreSQL
• Heads in the cloud at CHAR(10)
• “PostgreSQL 9.0 High Performance” book is out
• How not to build PostgreSQL 9.0 extensions on RPM platforms
• Hinting at PostgreSQL
• Data generation and hardware quality
• PostgreSQL training for MySQLers
• 2ndQuadrant Deutschland – Special Training Opening Bargain
• Spring 2011 PostgreSQL Conferences, US/Canada
• PostgreSQL agent in SQL Standard committee again
• PostGIS In Action
• The cost of free PostgreSQL publicity
• Planetary alignment
• Early bird registrations open for PGDay.IT 2011
• Call for papers for PGDay.IT 2011 has been extended
• CTE and the Birthday Paradox
• How do PostgreSQL security_barrier views work?
• Announcing repmgr 2.0RC2
• Announcing repmgr 2.0
• Indexando ando: Índices GIN
• Performance limits of logical replication solutions
• Tables and indexes vs. HDD and SSD
• PostgreSQL User Group NL
• On the impact of full-page writes
• Looking forward to PGConf India 2017
• Autovacuum Tuning Basics
• XMLTABLE in PostgreSQL
• More robust collations with ICU support in PostgreSQL 10
• In the defense of sar (and how to configure it)
• PostgreSQL 10 identity columns explained
• What’s new in Postgres-XL 9.6
• Future of Postgres-XL
• Oracle High Availability concepts in PostgreSQL
• Here’s How You Can Run OmniDB On Postgres10 [VIDEO]
• PostgreSQL Meltdown Benchmarks
• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
• Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
• Prague PostgreSQL Meetup
• 2ndQuadrant at PostgresConf US 2018
• Postgres Installer – A GUI based, user-friendly installer for PostgreSQL
• [Video] Introduction to JSON data types in PostgreSQL
• Postgres Installer – A Step by Step Guide to install PostgreSQL
• Talk slides: Partitioning Improvements in PostgreSQL 11
• Managing Freezing in PostgreSQL
• [Video] Data Integration with PostgreSQL
• Upgrading to PostgreSQL 11 with Logical Replication
• Partitioning Improvements in PostgreSQL 11
• PostgreSQL 11: Patch Reviewers for Partitioning Patches
• [Video] Power of Indexing in PostgreSQL
• Webinar : New Features in PostgreSQL 11 [Follow Up]
• [Video] Ansible and PostgreSQL
• PostgreSQL 9.3 EOL – Why is it Important to Upgrade?
• Webinar: Banking on Postgres – Financial Application Considerations [Follow up]
• JOIN LATERAL
• Measuring PostgreSQL Checkpoint Statistics
• Telling Your Users to Go Fork Themselves
• Updates to PostgreSQL testing tools with benchmark archive
• Reducing the postgresql.conf, parameter at a time
• Linux filesystems and PostgreSQL checkpoint benchmarks
• Intel SSD, now off the sh..err, shamed list
• Announcing Barman 1.0, Backup and Recovery Manager for PostgreSQL
• Tracing PostgreSQL with perf
• PostgreSQL guts: What is “resjunk”?
• Progress on online upgrade
• The CHECK clause for updatable views
• Automating Barman with Puppet: it2ndq/barman (part one)
• Automating Barman with Puppet: it2ndq/barman (part two)
• Why should you learn PostgreSQL?
• What’s New in PgBouncer 1.6
• Working towards Postgres-XL 9.5
• Tablesample and Other Methods for Getting Random Tuples
• Ansible Loves PostgreSQL
• PostgreSQL Planet in Ansible Galaxy
• Benchmarking Postgres-XL
• Performance of Sequences and Serials in Postgres-XL
• On pglogical performance
• PgBouncer 1.7 – “Colors Vary After Resurrection”
• Prague PostgreSQL Developer Day 2016
• FLOSS UK Spring Conference
• Managing a PostgreSQL Commitfest
• Are we ready for Nordic PGDay?
• pgpredict – Predictive analytics in PostgreSQL
• Code coverage stats
• On the usefulness of expression indexes
• 9.6 Scariest Patch Tournament
• Column Store Plans
• PGLogical 1.1 packages for PostgreSQL 9.6beta1
• Auditing Users and Roles in PostgreSQL
• PostgreSQL-based application performance: latency and hidden delays
• Application users vs. Row Level Security
• Evolution of Fault Tolerance in PostgreSQL
• Evolution of Fault Tolerance in PostgreSQL: Replication Phase
• PostgreSQL 9.6: Parallel Sequential Scan
• On the benefits of sorted paths
• PostgreSQL vs. Linux kernel versions
• pgFincore 1.2, une extension PostgreSQL
• Evolution of Fault Tolerance in PostgreSQL: Time Travel
• Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit
• Those darn Large Objects
• Untangling the PostgreSQL upgrade
• Basics of Tuning Checkpoints
• When autovacuum does not vacuum
• Having Group By Clauses — elein’s GeneralBits
• Postgres is the coolest database – Reason #1: Developers love it!
• Postgres is the coolest database – Reason #2: The License
• Webinar: Security and Compliance with PostgreSQL [Follow Up]
• Webinar: Business Intelligence with Window Functions in PostgreSQL [Follow up]
• Webinar: New Features in Postgres 12 [Follow up]
• PostgreSQL 12: Foreign Keys and Partitioned Tables
• Managing another PostgreSQL Commitfest
• Webinar: PostgreSQL Partitioning [Follow up]
• PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes
• Setting SSL/TLS protocol versions with PostgreSQL 12
• How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1

Rafael's PlanetPostgreSQL

• OmniDB – Now with PL/pgSQL debugger!

repmgr

• Announcing repmgr 2.0RC2
• Announcing repmgr 2.0
• repmgr 3.2 is here with Barman support and Brand New High Availability features
• Announcing repmgr 2.0RC1
• Replication configuration changes in PostgreSQL 12
• How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1

Rubens' PlanetPostgreSQL

• And Barman 1.6.0 is out!
• Inserting JSONB data in PostgreSQL 9.6
• JSONB and PostgreSQL 9.5: with even more powerful tools!

Sadeq's PlanetPostgreSQL

• How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1

Shaun's PlanetPostgreSQL

• PG Phriday: Dearly De-parted
• PG Phriday: Postgres on Tap
• PG Phriday: Uptown Func
• PG Phriday: Crazy Correlated Column Crusade
• PG Phriday: Smooth Operator
• PG Phriday: pglogical and Postgres 10 Partitions
• PG Phriday: Getting RAD with Docker [Part 1]
• PG Phriday: Getting RAD with Docker [Part 3]
• PG Phriday: Getting RAD with Docker [Part 4]
• PG Phriday: Postgres on ZFS
• PG Phriday: Adventures in BAR Management
• PG Phriday: Securing PgBouncer
• [Video] Data Integration with PostgreSQL
• On Rocks and Sand
• PG Phriday: Studying Stored Procedures in Postgres 11
• PG Phriday: PgBouncer or Bust
• PG Phriday: Terrific Throughput Tracking
• PG Phriday: Getting RAD with Docker [Part 2]
• PG Phriday: BDR Around the Globe
• I am Developer! (And You Can Too!)
• PG Phriday: Around the World in Two Billion Transactions
• PG Phriday: Postgres 12 Revs up Vacuum

Simon's PlanetPostgreSQL

• Planning to succeed
• Cool Runnings
• Highlights of PGconf.EU
• Avoiding Disasters in New York
• CHAR(16) Scalability for Business
• CHAR16 Conf Panel Video
• PostgreSQL’s Popularity Goes Up Again
• What does pg_start_backup() do?
• Dataloss at GitLab
• PgDay Paris 2017
• PostgreSQL Popularity Continues to Grow!
• News and Roadmap for BDR (Multi-master PostgreSQL)
• PG10 at the London PostgreSQL Meetup
• Why PostgreSQL is better than MySQL
• Oracle High Availability concepts in PostgreSQL
• PostgreSQL is the DBMS of the Year 2017
• PostgreSQL Meltdown
• Upcoming Enhancements to Partitioning & Indexes in PostgreSQL 11
• PostgreSQL Maximum Table Size
• PostgreSQL Developer Meeting Brussels
• PostgreSQL – The most loved RDBMS
• The End of MongoDB
• Joins Don’t Scale!
• Why Logical Replication?
• The Physics of Multi-Master
• PgDay France 2016
• Finding your PostgreSQL version
• Oracle’s rising open source problem
• Report from DatabaseCamp, NYC
• PostgreSQL 10 Roadmap
• Thoughts on Uber’s List of Postgres Limitations
• PostgreSQL Solutions Roadmap
• PostgreSQL 9.1 End of Life
• When to use Postgres-BDR or Postgres-XL?
• Postgres-BDR: 2 Years in Production
• PostgreSQL Solution Architecture
• How long does it take to change your mind?
• Supporting the Elephant

Susanne's PlanetPostgreSQL

• 100% PostgreSQL again
• PostgreSQL agent in SQL Standard committee again

Time Series Data

• Using Window Functions for Time Series IoT Analytics in Postgres-BDR

Tom's PlanetPostgreSQL

• pgxc_ctl: Teaching Postgres-XL in New York City
• [Video] Ansible and PostgreSQL
• Postgres-BDR: It is also about fast safe upgrades

Tomas' PlanetPostgreSQL

• Performance limits of logical replication solutions
• Tables and indexes vs. HDD and SSD
• On the impact of full-page writes
• Autovacuum Tuning Basics
• In the defense of sar (and how to configure it)
• What’s new in Postgres-XL 9.6
• Future of Postgres-XL
• PostgreSQL Meltdown Benchmarks
• Sequential UUID Generators
• Databases vs. encryption
• Sequential UUID Generators on SSD
• On pglogical performance
• On the usefulness of expression indexes
• Auditing Users and Roles in PostgreSQL
• Application users vs. Row Level Security
• On the benefits of sorted paths
• PostgreSQL vs. Linux kernel versions
• Basics of Tuning Checkpoints
• When autovacuum does not vacuum

Umair's PlanetPostgreSQL

• The process that created pglogical
• Postgres-XL 9.5: Gearing Towards the Beta Release
• Using Hibernate Query Language (HQL) with PostgreSQL
• Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6
• The PostgreSQL License – What Does It Mean For My Business?
• Processing PostgreSQL JSON & JSONB data in Java
• JOOQ Object Oriented Querying (jOOQ)
• Using Java Database Interface (jDBI) with PostgreSQL
• Using Java ORMs with PostgreSQL – MyBatis
• Using EclipseLink with PostgreSQL
• PostgreSQL 11 – Server-side Procedures (Part 1)
• PostgreSQL 11 – Server-side Procedures (Part 2)
• PGConf APAC 2018 – bigger & better each year
• Creating a PostgreSQL Service on Ubuntu
• 2ndQ talks at PGDay FOSDEM 2016
• Using Java arrays to insert, retrieve, & update PostgreSQL arrays
• Using Java Object Oriented Querying (jOOQ) with PostgreSQL
• Using Querydsl with PostgreSQL
• My experience with the Indonesia PUG meetup
• 2UDA – Installing PostgreSQL 9.6 the easy way
• v10, The Best PostgreSQL Yet?
• Postgres is the coolest database – Reason #1: Developers love it!
• Postgres is the coolest database – Reason #2: The License
• Postgres is the coolest database – Reason #3: No vendor lock-in
• Postgres is the coolest database – Reason #4: It is extendable
• Postgres is the coolest database – Reason #5: It can not be bought out

Uncategorized

United Kingdom News

• 2ndQuadrant Italia supports students affected by L’Aquila earthquakes
• Hot Standby User Group (online) – 13 Jan at 1600UTC
• 2ndQuadrant US Launch Party – February 12 New York City – Canceled
• Easier PostgreSQL 9.0 clusters with repmgr
• How not to build PostgreSQL 9.0 extensions on RPM platforms
• EuroPython 2011: “The Python and the Elephant”
• Enterprise Support – The final hurdle for PostgreSQL?
• FLOSS UK Spring Conference

United States News

• Hot Standby User Group (online) – 13 Jan at 1600UTC
• 2ndQuadrant US Launch Party – February 12 New York City – Canceled
• PGEast, Hardware Benchmarking, and the PG Performance Farm
• PostgreSQL Performance and PGWest
• “PostgreSQL 9.0 High Performance” book is out
• PG West talks
• PostgreSQL CommitFest #3 for 9.1 needs you!
• Easier PostgreSQL 9.0 clusters with repmgr
• How not to build PostgreSQL 9.0 extensions on RPM platforms
• Tuning Linux for low PostgreSQL latency
• Hinting at PostgreSQL
• Data generation and hardware quality
• Spring 2011 PostgreSQL Conferences, US/Canada
• The cost of free PostgreSQL publicity
• CHAR (16) – Another conference on the horizon but with a focus on business
• Reducing the postgresql.conf, parameter at a time
• Linux filesystems and PostgreSQL checkpoint benchmarks
• Intel SSD, now off the sh..err, shamed list

User Group

• PostgreSQL User Group NL
• Prague PostgreSQL Meetup

Vik's PlanetPostgreSQL

• Schedule is live for pgDay Paris 2017 on March 23!

Webinars

• Webinar: Introduction to JSON data types in PostgreSQL [Follow Up]
• Webinar: Data Integration With PostgreSQL [Follow Up]
• Power of Indexing in PostgreSQL [Webinar Follow-up]
• Introduction to Postgres-BDR [Webinar Follow-up]
• Webinar : Database Security in PostgreSQL [Follow Up]
• Webinar: Banking on Postgres – Financial Application Considerations [Follow up]
• Webinar : Ansible & PostgreSQL [Follow Up]
• Webinar: Security and Compliance with PostgreSQL [Follow Up]
• Webinar: Migration to PostgreSQL [Follow up]
• Webinar: Postgres Vacuuming Through Pictures [Follow up]
• Webinar: Business Intelligence with Window Functions in PostgreSQL [Follow up]
• Webinar: New Features in Postgres 12 [Follow up]
• Webinar: PostgreSQL Partitioning [Follow up]
• Webinar: Using SSL with PostgreSQL and pgbouncer [Follow Up]
• Webinar: You forgot to put the WHERE in DELETE? [Follow Up]
• Webinar: BDR – Latest Features & Updates [Follow Up]

William's PlanetPostgreSQL

• OmniDB: Average execution time of PostgreSQL webmethods
• PostgreSQL 10 Logical Replication with OmniDB
• Postgres-BDR with OmniDB
• Postgres-XL with OmniDB
• pglogical with OmniDB
• OmniDB: Monitoring Dashboard
• Oracle with OmniDB
• OmniDB: Console Tab
• Postgres-BDR 3.0 with OmniDB
• OmniDB debugger for PostgreSQL 11