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 / Blog2 / PostgreSQL

Posts

PostgreSQL Partitioning by Simon Riggs [Full Webinar Video]

October 23, 2020/1 Comment/in Webinars /by Bilal Ibrar

This webinar on PostgreSQL Partitioning (originally conducted in 2019), is now available to watch on our YouTube channel. This webinar gave an overview of PostgreSQL partitioning and how it plays a key role in sensible management and improved performance with very large databases. Particular use cases were also highlighted, along with taking a look at […]

Read more

Webinar: Highway to Zero Downtime PostgreSQL Upgrades [Follow Up]

October 5, 2020/0 Comments/in Webinars /by Bilal Ibrar

In the past, major upgrades of terabyte size PostgreSQL databases required extended downtime or great amounts of work. With logical decoding, a whole new world of opportunities appeared for upgrades that require a very small amount of downtime. This webinar gave a comprehensive overview of how to perform a “near” zero downtime upgrade using pglogical, […]

Read more

PostgreSQL VACUUM and ANALYZE Best Practice Tips

September 30, 2020/3 Comments/in 2ndQuadrant, PostgreSQL, PostgreSQL 13, Sadeq's PlanetPostgreSQL /by 2ndQuadrant Press

VACUUM and ANALYZE are the two most important PostgreSQL database maintenance operations.  A vacuum is used for recovering space occupied by “dead tuples” in a table. A dead tuple is created when a record is either deleted or updated (a delete followed by an insert). PostgreSQL doesn’t physically remove the old row from the table […]

Read more

PostgreSQL, a community project

September 29, 2020/0 Comments/in Eisentraut's PlanetPostgreSQL /by Peter Eisentraut

PostgreSQL 13 was released last week. As a PostgreSQL developer, of course I monitor the news and social media on days like this to see what the public thinks about our release and maybe which features get discussed most. The latter is always surprising. What I noticed particularly this year was that most of the […]

Read more

Smart R2DBC Repositories for PostgreSQL Databases

September 29, 2020/0 Comments/in 2ndQuadrant, Haroon's PlanetPostgreSQL /by Muhammad Haroon

Continuing on from the Reactive Spring Boot application development blogs we authored and provided samples for in the last two blogs (part 1 and part 2), we will now move on and discuss how to design and deploy “intelligent” repositories for R2DBC project for PostgreSQL. The purpose of this post is to show you an […]

Read more

New Features in PostgreSQL 13 [Full Webinar Video]

September 24, 2020/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat Andrabi

The PostgreSQL Global Development Group today announced the release of PostgreSQL 13. The new release boasts improvements in performance and security as well as notable features such as the SQL-standard WITH TIES clause to use with LIMIT, B-tree deduplication, improvements for large databases, and more. The many features and enhancements in PostgreSQL 13 help improve […]

Read more

Webinar: New Features in PostgreSQL 13 [Follow Up]

September 21, 2020/0 Comments/in Webinars /by Bilal Ibrar

There are numerous features and enhancements in PostgreSQL 13 that help improve the overall performance of PostgreSQL while making it considerably easier to develop and manage applications. The PostgreSQL community has been able to release a major revision every year, demonstrating their amazing vitality and creativity — and in order to take a deep dive […]

Read more

7 Best Practice Tips for PostgreSQL Bulk Data Loading

September 15, 2020/3 Comments/in PostgreSQL, PostgreSQL 13, Sadeq's PlanetPostgreSQL /by 2ndQuadrant Press

Sometimes, PostgreSQL databases need to import large quantities of data in a single or a minimal number of steps. This process can be sometimes unacceptably slow. In this article, we will cover some best practice tips for bulk importing data into PostgreSQL databases.

Read more

Which partition contains a specific row in my PostgreSQL database?

September 9, 2020/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

If you are enjoying working with PostgreSQL declarative partitioning, you might be wondering how to check which partition contains a specific record. While it is quite obvious in the cases of list or range partitioning, it is a bit trickier with hash partitioning. Don’t worry. Here you can find a quick way to determine which […]

Read more

Webinar: JSON & ARRAY – Contemporary PostgreSQL Data Types [Follow Up]

September 4, 2020/0 Comments/in Webinars /by Bilal Ibrar

The Entity-Attribute-Value (EAV) data model is a design pattern to overcome the limitations of traditional relational databases. Its goal is to encode entities with a variable and a disparate number of attributes. It is efficient in terms of storage and it respects the rules of normalization. However, it doesn’t scale well, it degrades performance in […]

Read more
Page 1 of 28123›»

Search

Get in touch with us!

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

Featured External Blogs

Tomas Vondra's Blog

Our Bloggers

  • Simon Riggs
  • Alvaro Herrera
  • Andrew Dunstan
  • Craig Ringer
  • Francesco Canovai
  • Gabriele Bartolini
  • Giulio Calacoci
  • Ian Barwick
  • Marco Nenciarini
  • Mark Wong
  • Pavan Deolasee
  • Petr Jelinek
  • Shaun Thomas
  • Tomas Vondra
  • Umair Shahid

PostgreSQL Cloud

2QLovesPG 2UDA 9.6 backup Barman BDR Business Continuity community conference database DBA development devops disaster recovery greenplum Hot Standby JSON JSONB logical replication monitoring OmniDB open source Orange performance PG12 pgbarman pglogical PG Phriday postgres Postgres-BDR postgres-xl PostgreSQL PostgreSQL 9.6 PostgreSQL10 PostgreSQL11 PostgreSQL 11 PostgreSQL 11 New Features postgresql repmgr Recovery replication security sql wal webinar webinars

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
×