Blog - 2ndQuadrant | PostgreSQL

When to deploy or upgrade to a new major PostgreSQL release

September 25, 2020/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

With the release yesterday of PostgreSQL 13, now is perhaps a good time to talk about when and how it should be deployed. We often get questions at such times like "When should I upgrade?" and "Should I switch my new planned deployment to the new release?" The first thing to consider is this: you […]

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 […]

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 […]

PostgreSQL 13: LIMIT … WITH TIES

September 16, 2020/3 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL 13 /by Álvaro Herrera

A simple description of the new WITH TIES standard feature in PostgreSQL 13.

7 Best Practice Tips for PostgreSQL Bulk Data Loading

September 15, 2020/1 Comment/in PostgreSQL, PostgreSQL 13, Sadeq's PlanetPostgreSQL /by Sadequl Hussain

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.

PG Phriday: 10 Things Postgres Could Improve – Part 3

September 11, 2020/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

At the core of the “10 Things I Hate About PostgreSQL” blog post, sits one particular observation that seems like a simple annoyance at first glance. MVCC is presented merely as item 4 in the list, but like XIDs, it serves as a star upon which an entire constellation of related stellar objects converge. While […]

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 […]

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 […]

How to Get the Best Out of PostgreSQL Logs

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

Learn how to effectively configure PostgreSQL log management for troubleshooting performance problems.

Business Intelligence with Window Functions in PostgreSQL [Webinar]

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

Window functions in PostgreSQL are a very useful tool; and since their introduction 10 years ago, they have been gradually adopted for various use cases where a simple aggregation is just not flexible enough — case in point, incremental totals and moving averages. The features introduced in PostgreSQL complete the implementation according to the SQL:2011 […]