2ndQuadrant is now part of EDB

Bringing together some of the world's top PostgreSQL experts.

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • EN
    • FR
    • IT
    • ES
    • DE
    • PT
  • Support & Services
  • Products
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Blog
    • Training
      • Course Catalogue
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook – Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / Sitemap

Pages

  • Blog
  • 24/7 PostgreSQL Support
  • Developer Support
  • Webinar Library
  • 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
    • February 19, 2020 – Announcing the Release of pglogical 2.3
    • Announcing the release of repmgr 5.1
    • Announcing Postgres Installer for PostgreSQL 13 Beta 1
    • July 9, 2020 – Announcing the Release of Barman v2.11
    • September 24, 2020 – 2ndQuadrant Contributes Major Features to PostgreSQL 13
    • October 5, 2020 – Announcing the Release of pglogical 2.3.3
    • Announcing the Release of repmgr 5.2.0
    • Announcing the Release of OmniDB 3.0 – Now Supporting PostgreSQL 13
    • EDB to Host Free Virtual Conference for PostgreSQL Users in Europe
    • Announcing the Release of Barman v2.12
  • 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
    • The Business Case for PostgreSQL
    • PostgreSQL Blog Listing
    • Security Information
  • Training
    • Course Catalog
    • 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
  • Postgres Installer
    • Release Notes
  • 2UDA
    • Predictive Analytics with 2UDA
  • Contact Us
  • Professional PostgreSQL
  • Related Articles and Resources Template
  • Postgres Learning Center
  • Whitepapers
  • Sitemap
  • Videos
  • Online Training
  • Compliance at 2ndQuadrant
  • Fireside Chats
  • Upcoming Webinars
  • Online Training: PostgreSQL Database Administration
  • Online Training: PostgreSQL Database Administration
  • Contact us
  • test page for including related
  • Blog Backlink
  • test new page
  • Services
  • Products
  • Remote DBA for PostgreSQL
  • PostgreSQL Database Monitoring
  • PostgreSQL Health Check
  • PostgreSQL Performance Tuning
  • PostgreSQL Database Security Audit
  • Upgrade PostgreSQL
  • PostgreSQL Migration Assessment
  • Remote DBA for PostgreSQL
  • Migrate from Oracle to PostgreSQL
  • Postgres-BDR®
  • 2ndQPostgres
  • pglogical
  • Replication & Failover Management for Postgres
  • Barman
  • SQL Firewall
  • Postgres-XL
  • omniDB
  • AXLE
  • PostgreSQL High Availability
  • BDR
  • pgpredict – Predictive Analytics for PostgreSQL
  • Managed PostgreSQL in the Cloud
  • Kubernetes Operators for Highly Available PostgreSQL and BDR
  • IoT Solution
  • Postgres-BDR® Deployment Options
  • BDR – The 3rd Generation
  • Installation Instructions for pglogical
  • pglogical Documentation
  • Release Notes
  • Installation Instructions for repmgr
  • Migrazione da Oracle®
  • pgpredict – Tutorial

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]
  • 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
  • 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
  • PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes
  • Webinar: Using SSL with PostgreSQL and pgbouncer [Follow Up]
  • Barman Cloud – Part 1: WAL Archive
  • How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)
  • Releasing Cloud Native BDR Operator for Kubernetes
  • Researching PostGIS slowness (2019 edition)
  • Announcing New PostgreSQL Online Training Series
  • How to use the SVM Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 2)
  • Webinar: All you need to know about CREATE STATISTICS [Follow Up]
  • Business Continuity at 2ndQuadrant – How We Remain Effective in Emergencies
  • How to Protect Your PostgreSQL Databases from Cyberattacks with SQL Firewall
  • How to use the Random Forest Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 3)
  • Oracle to PostgreSQL: ANSI outer join syntax in PostgreSQL
  • How to use Tree Machine Learning model with 2UDA – PostgreSQL and Orange (Part 4)
  • How to use Logistic Regression Machine Learning model with 2UDA – PostgreSQL and Orange (Part 5)
  • Oracle to PostgreSQL: START WITH/CONNECT BY
  • Sequential UUID Generators on SSD
  • How to use AdaBoost Machine Learning model with 2UDA – PostgreSQL and Orange (Part 6)
  • Oracle to PostgreSQL: Basic Architecture
  • Setting SSL/TLS protocol versions with PostgreSQL 12
  • Oracle to PostgreSQL: Reasons to Migrate
  • Local Persistent Volumes and PostgreSQL usage in Kubernetes
  • PostgreSQL is the worlds’ best database
  • How to use Neural Network Machine Learning model with 2UDA – PostgreSQL and Orange (Part 7)
  • How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1
  • Oracle to PostgreSQL – Binary Objects
  • Machine‌ ‌Learning‌ ‌with‌ ‌2UDA‌ ‌-‌ ‌PostgreSQL‌ ‌and‌ ‌ Orange‌ ‌-‌ ‌Concluding‌ ‌the‌ ‌series‌
  • Barman Cloud – Part 2: Cloud Backup
  • Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore
  • Generating and Managing PostgreSQL Database Migrations(Upgrades) with Spring Boot JPA
  • How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2
  • PostgreSQL 13: Don’t let slots kill your primary
  • Oracle to PostgreSQL — Cursors and Common Table Expressions
  • Advanced partition matching for partition-wise join
  • Webinar: PostgreSQL on Windows [Follow Up]
  • Oracle to PostgreSQL — Cursors and ltrees
  • Building Reactive PostgreSQL Repositories for Spring Boot Applications – Part 1
  • Parallelism comes to VACUUM
  • Building Reactive PostgreSQL Repositories for Spring Boot Applications – Part 2
  • Image classification using 2UDA – Orange
  • How to Get the Best Out of PostgreSQL Logs
  • PostgreSQL 13: LIMIT … WITH TIES
  • TPC-H performance since PostgreSQL 8.3
  • Full-text search since PostgreSQL 8.3
  • Smart R2DBC Repositories for PostgreSQL Databases
  • PostgreSQL VACUUM and ANALYZE Best Practice Tips
  • Webinar: Managing and Monitoring PostgreSQL Clusters with OmniDB [Follow Up]
  • Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up]
  • Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up]

Alvaro's PlanetPostgreSQL

  • XMLTABLE in PostgreSQL
  • Talk slides: Partitioning Improvements in PostgreSQL 11
  • Partitioning Improvements in PostgreSQL 11
  • 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
  • Researching PostGIS slowness (2019 edition)
  • PostgreSQL 11: Patch Reviewers for Partitioning Patches
  • PostgreSQL 13: Don’t let slots kill your primary
  • PostgreSQL 13: LIMIT … WITH TIES

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
  • 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
  • [Video] Introduction to JSON data types in PostgreSQL
  • Partitioning a large table without a long-running lock
  • NSS on Windows for PostgreSQL development
  • Updating the PostgreSQL root.crt file
  • When to deploy or upgrade to a new major PostgreSQL release

Anna's PlanetPostgreSQL

  • Barman 2.10 – Recovery of partial WAL files
  • Barman Cloud – Part 2: Cloud Backup
  • Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore

Ashustosh's Planet PostgreSQL

  • Advanced partition matching for partition-wise join

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
  • Barman Cloud – Part 1: WAL Archive
  • Barman Cloud – Part 2: Cloud Backup
  • Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore

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!

Caterina's PlanetPostgreSQL

  • How to migrate from inheritance-based partitioning to declarative partitioning in PostgreSQL

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

Cloud Native

  • Releasing Cloud Native BDR Operator for Kubernetes
  • Automated rapid switchover with a BDR database cluster in Kubernetes
  • How to deploy a multi-master BDR cluster in Kubernetes
  • Local Persistent Volumes and PostgreSQL usage in Kubernetes
  • Why we chose immutable application containers for our Cloud Native PostgreSQL and BDR products

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
  • 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
  • Failover slots for PostgreSQL

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)
  • Barman Cloud – Part 1: WAL Archive
  • Barman Cloud – Part 2: Cloud Backup
  • Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore

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
  • Developing PostgreSQL for Windows, Part 1
  • Developing PostgreSQL for Windows, Part 2
  • Developing PostgreSQL for Windows, Part 3
  • A tale of password authentication methods in PostgreSQL
  • PostgreSQL with passphrase-protected SSL keys under systemd
  • Understanding user management in PgBouncer
  • Unicode normalization in PostgreSQL 13
  • Running multiple PgBouncer instances with systemd
  • PostgreSQL, a community project

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
  • WITH a little help from my friends

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
  • Barman Cloud – Part 1: WAL Archive
  • Business Continuity at 2ndQuadrant – How We Remain Effective in Emergencies

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
  • Backup manifests and pg_verifybackup in PostgreSQL 13
  • Which partition contains a specific row in my PostgreSQL database?

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
  • RESTful CRUD API using PostgreSQL and Spring Boot – Part one
  • RESTful CRUD API using PostgreSQL and Spring Boot – Part 2 
  • Bulk transactions with RESTful CRUD API using PostgreSQL and Spring Boot 
  • Generating and Managing PostgreSQL Database Migrations(Upgrades) with Spring Boot JPA
  • Building Reactive PostgreSQL Repositories for Spring Boot Applications – Part 1
  • Building Reactive PostgreSQL Repositories for Spring Boot Applications – Part 2
  • Smart R2DBC Repositories for PostgreSQL Databases

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

Jimmy's Planet PostgreSQL

  • Keep your libraries updated and nobody gets hurt

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
  • Barman Cloud – Part 1: WAL Archive

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
  • Oracle to PostgreSQL: ANSI outer join syntax in PostgreSQL
  • Oracle to PostgreSQL: START WITH/CONNECT BY
  • Oracle to PostgreSQL: Basic Architecture
  • Oracle to PostgreSQL: Reasons to Migrate
  • PostgreSQL is the worlds’ best database
  • Oracle to PostgreSQL – Binary Objects
  • Oracle to PostgreSQL — Cursors and Common Table Expressions
  • Oracle to PostgreSQL — Cursors and ltrees

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]
  • Security and Compliance with PostgreSQL [Webinar]
  • Migration to PostgreSQL [Webinar]
  • Postgres Vacuuming Through Pictures [Webinar]
  • Business Intelligence with Window Functions in PostgreSQL [Webinar]
  • New Features in PostgreSQL 13 [Full Webinar Video]

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
  • Creating a PostgreSQL procedural language – Part 1 – Setup
  • Creating a PostgreSQL procedural language – Part 2 – Embedding Julia
  • Creating a PostgreSQL procedural language – Part 3 – Executing User Code
  • Creating a PostgreSQL procedural language – Part 4 – Handling Input Parameters
  • Creating a PostgreSQL procedural language – Part 5 – Returning Results
  • Random numbers
  • Random Data

Marriya's PlanetPostgreSQL

  • Postgres Installer by 2ndQuadrant – now supports OmniDB!

Masahiko's Planet PostgreSQL

  • Parallelism comes to VACUUM

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]
  • How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1

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
  • 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
  • [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: New Features in Postgres 12 [Follow up]
  • PostgreSQL 12: Foreign Keys and Partitioned Tables
  • Managing another PostgreSQL Commitfest
  • PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes
  • Developing PostgreSQL for Windows, Part 1
  • How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1
  • Barman Cloud – Part 1: WAL Archive
  • How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)
  • How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2
  • Researching PostGIS slowness (2019 edition)
  • Developing PostgreSQL for Windows, Part 2
  • How to Protect Your PostgreSQL Databases from Cyberattacks with SQL Firewall
  • Developing PostgreSQL for Windows, Part 3
  • A tale of password authentication methods in PostgreSQL
  • Oracle to PostgreSQL: ANSI outer join syntax in PostgreSQL
  • Oracle to PostgreSQL: START WITH/CONNECT BY
  • PostgreSQL 11: Patch Reviewers for Partitioning Patches
  • [Video] Introduction to JSON data types in PostgreSQL
  • Oracle to PostgreSQL: Basic Architecture
  • Oracle to PostgreSQL: Reasons to Migrate
  • PostgreSQL is the worlds’ best database
  • How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1
  • Unicode normalization in PostgreSQL 13
  • Barman Cloud – Part 2: Cloud Backup
  • Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore
  • How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2
  • PostgreSQL 13: Don’t let slots kill your primary
  • Oracle to PostgreSQL — Cursors and Common Table Expressions
  • Advanced partition matching for partition-wise join
  • Oracle to PostgreSQL — Cursors and ltrees
  • Parallelism comes to VACUUM
  • How to Get the Best Out of PostgreSQL Logs
  • PostgreSQL 13: LIMIT … WITH TIES
  • OLTP performance since PostgreSQL 8.3
  • TPC-H performance since PostgreSQL 8.3
  • Full-text search since PostgreSQL 8.3
  • 7 Best Practice Tips for PostgreSQL Bulk Data Loading
  • PostgreSQL VACUUM and ANALYZE Best Practice Tips
  • How EDB Became the Leader in the Postgres Market

PostgreSQL 13

  • PostgreSQL 13: Don’t let slots kill your primary
  • Advanced partition matching for partition-wise join
  • Parallelism comes to VACUUM
  • How to Get the Best Out of PostgreSQL Logs
  • PostgreSQL 13: LIMIT … WITH TIES
  • 7 Best Practice Tips for PostgreSQL Bulk Data Loading
  • PostgreSQL VACUUM and ANALYZE Best Practice Tips

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
  • How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2

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
  • How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2
  • How to Protect Your PostgreSQL Databases from Cyberattacks with SQL Firewall
  • How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1
  • How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2
  • How to Get the Best Out of PostgreSQL Logs
  • 7 Best Practice Tips for PostgreSQL Bulk Data Loading
  • PostgreSQL VACUUM and ANALYZE Best Practice Tips

Seemab's PlanetPostgreSQL

  • How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)
  • How to use the SVM Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 2)
  • How to use the Random Forest Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 3)
  • How to use Tree Machine Learning model with 2UDA – PostgreSQL and Orange (Part 4)
  • How to use Logistic Regression Machine Learning model with 2UDA – PostgreSQL and Orange (Part 5)
  • How to use AdaBoost Machine Learning model with 2UDA – PostgreSQL and Orange (Part 6)
  • How to use Neural Network Machine Learning model with 2UDA – PostgreSQL and Orange (Part 7)
  • Machine‌ ‌Learning‌ ‌with‌ ‌2UDA‌ ‌-‌ ‌PostgreSQL‌ ‌and‌ ‌ Orange‌ ‌-‌ ‌Concluding‌ ‌the‌ ‌series‌

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
  • PG Phriday: 10 Things Postgres Could Improve – Part 1
  • PG Phriday: 10 Things Postgres Could Improve – Part 2
  • PG Phriday: It’s the End of the World as We Know it (and Postgres is Fine)
  • PG Phriday: 10 Things Postgres Could Improve – Part 3

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

Technology

  • How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2

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
  • 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
  • Sequential UUID Generators on SSD
  • OLTP performance since PostgreSQL 8.3
  • TPC-H performance since PostgreSQL 8.3
  • Full-text search since PostgreSQL 8.3

training

  • Announcing New PostgreSQL Online Training Series

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: New Features in Postgres 12 [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]
  • Webinar: Application Schema Migration [Follow Up]
  • Webinar: All you need to know about CREATE STATISTICS [Follow Up]
  • Webinar: State of Full Text Search in PostgreSQL 12 [Follow Up]
  • Webinar: Identity Columns and Generated Columns in PostgreSQL [Follow Up]
  • Webinar: pg_catalog Unveiled! [Follow Up]
  • Webinar: Creating Graph Databases in PostgreSQL [Follow Up]
  • Webinar: Date/Timestamp types in PostgreSQL [Follow Up]
  • Webinar: KNN Indexing in PostgreSQL [Follow Up]
  • Security and Compliance with PostgreSQL [Webinar]
  • Webinar: MVCC and Vacuum Basics in PostgreSQL [Follow Up]
  • Webinar: Collations: Introduction, Features, Problems [Follow Up]
  • Webinar: Tuple Freezing & Transaction Wrap around Through Pictures [Follow Up]
  • Webinar: Cloud Native BDR and PostgreSQL [Follow Up]
  • Webinar: PostgreSQL deployments & TPAexec [Follow Up]
  • Webinar: PostgreSQL continuous backup and PITR with Barman [Follow Up]
  • Webinar: Understanding the PostgreSQL table page layout [Follow Up]
  • Webinar: Fantastic Data Types and Where to Use Them [Follow Up]
  • Webinar: PostgreSQL Partitioning Roadmap [Follow Up]
  • Migration to PostgreSQL [Webinar]
  • Fireside Chat: BDR – Advanced Clustering & Scaling for PostgreSQL [Follow Up]
  • Webinar: Enhancing Postgres High Availability [Follow Up]
  • Webinar: Being Committed – A Review of Transaction Control Statements 1/3 [Follow Up]
  • Webinar: Being Committed – A Review of Transaction Control Statements 2/3 [Follow Up]
  • Webinar: Being Committed – A Review of Transaction Control Statements 3/3 [Follow Up]
  • Webinar: PostgreSQL on Windows [Follow Up]
  • Postgres Vacuuming Through Pictures [Webinar]
  • Webinar: Similarity Queries in PostgreSQL [Follow Up]
  • Business Intelligence with Window Functions in PostgreSQL [Webinar]
  • Webinar: JSON & ARRAY – Contemporary PostgreSQL Data Types [Follow Up]
  • Webinar: New Features in PostgreSQL 13 [Follow Up]
  • New Features in PostgreSQL 13 [Full Webinar Video]
  • Webinar: Highway to Zero Downtime PostgreSQL Upgrades [Follow Up]
  • Webinar: Managing and Monitoring PostgreSQL Clusters with OmniDB [Follow Up]
  • PostgreSQL Partitioning by Simon Riggs [Full Webinar Video]
  • Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up]
  • Webinar: COMMIT Without Fear – The Beauty of CAMO [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

Recent Posts

  • Random Data December 3, 2020
  • Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up] November 13, 2020
  • Full-text search since PostgreSQL 8.3 November 5, 2020
  • Random numbers November 3, 2020
  • Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up] November 2, 2020

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Scroll to top
×