Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 39 Sekunden

Andreas 'ads' Scherbaum: Regina Obe

7. September 2020 - 16:00
PostgreSQL Person of the Week Interview with Regina Obe: I live in Boston, Massachusetts (USA). I was born in Lagos, Nigeria in 1971 and spent the first 7 years of my life there. My father is Nigerian and mother is American. I moved to the US at age of 7ish when my mother started her medical residency. I think I’m still considered a dual citizen though I haven’t been back to Nigeria since.

Ryan Lambert: PostgreSQL 13Beta3: B-Tree index deduplication

6. September 2020 - 7:01

PostgreSQL 13 development is coming along nicely, Postgres 13 Beta3 was released on 8/13/2020. The Postgres Beta 1 and 2 releases were released in May and June 2020. One of the features that has my interest in Postgres 13 is the B-Tree deduplication effort. B-Tree indexes are the default indexing method in Postgres, and are likely the most-used indexes in production environments. Any improvements to this part of the database are likely to have wide-reaching benefits.

Marco Slot: What’s new in the Citus 9.4 extension to Postgres

5. September 2020 - 18:32

Our latest release to the Citus extension to Postgres is Citus 9.4. If you’re not yet familiar, Citus transforms Postgres into a distributed database, distributing your data and your SQL queries across multiple nodes. This post is basically the Citus 9.4 release notes.

If you’re ready to get started with Citus, it’s easy to download Citus open source packages for 9.4.

Nazli Ugur Koyluoglu: Mining for logic bugs in the Citus extension to Postgres with SQLancer

4. September 2020 - 7:51

Many of you rely on databases to return correct results for your SQL queries, however complex your queries might be. And you probably place your trust with no questions asked—since you know relational databases are built on top of proven mathematical foundations, and since there is no practical way to manually verify your SQL query output anyway.

Luca Ferrari: Hey there! I'm using PostgreSQL!

4. September 2020 - 2:00

A little contribution in spreading the PostgreSQL word!

Hey there! I’m using PostgreSQL!

A few weeks ago I changed my old mobile phone, and so I had to install again all my applications, including something I personally hate: WhatsApp.
While checking the configuration of the application, correctly and automatically cloned from my old phone, I came across the standard status that WhatsApp places for you:

Stefan Fercot: Combining pgBackRest and Streaming Replication, PG13 update

4. September 2020 - 2:00

pgBackRest is a well-known powerful backup and restore tool. It offers a lot of possibilities.

While pg_basebackup is commonly used to setup the initial database copy for the Streaming Replication, it could be interesting to reuse a previous database backup (eg. taken with pgBackRest) to perform this initial copy.

This content updates one of my old posts, using PostgreSQL 13 and the latest pgBackRest version.

Asif Rehman: PostgreSQL Backups

3. September 2020 - 19:56

In a database production environment, a backup plays quite an essential role. The database server can fail for a number of reasons. It can happen because of hardware failure, software malfunction or just because of user error. Whatever the reason, when a live database goes down, a backup is essential in fixing and recovering it.

In a database system, the data is stored in binary files. Every database provider offers some kind of backup tools using which database files may be backed up. PostgreSQL database server also provides a comprehensive set of tools.

Bruce Momjian: Changing Cars, Changing Databases

3. September 2020 - 17:30

It would be very easy if I drove the same car regularly, but because of my family size and travels, I don't have that luxury. Some cars I drive have smart keys, some mechanical keys. Some have gas tank doors on the driver's side, others from the passenger side. They steer differently, have different acceleration capabilities, even different service requirements. I have gotten used to switching cars, but still get confused when I have to fuel the car since I have to remember which side has the gas tank door.

Sadequl Hussain: How to Get the Best Out of PostgreSQL Logs

3. September 2020 - 13:36
Learn how to effectively configure PostgreSQL log management for troubleshooting performance problems.

Liaqat Andrabi: Business Intelligence with Window Functions in PostgreSQL [Webinar]

3. September 2020 - 11:28
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 […]

Kirk Roybal: Oracle to PostgreSQL — Cursors and ltrees

2. September 2020 - 17:34
This time we talk about using ltree as an alternative to PostgreSQL cursors.

Hans-Juergen Schoenig: PostgreSQL vs PostGreSQL vs Postgre vs Oracle vs all the rest

2. September 2020 - 11:00

Is it Postgre, PostGreSQL, Postgres or PostgreSQL? We have all seen a couple of wrong ways to spell “PostgreSQL”. The question therefore is: How can one find data even if there are typos? In PostgreSQL there are various solutions to the problem. Depending on what kind of search you need you can choose between various methods.

Before we get started it is necessary to compile some sample data:

Masahiko Sawada: Parallelism comes to VACUUM

2. September 2020 - 6:29
Vacuum is one of the most important features for reclaiming deleted tuples in tables and indexes. Without vacuum, tables and indexes would continue to grow in size without bounds. This blog post describes the PARALLEL option for VACUUM command, which is newly introduced to PostgreSQL13.  Vacuum Processing Phases Before discussing the new option in depth […]

Kat Batuigas: Three Easy Things To Remember About Postgres Indexes

1. September 2020 - 21:17

If you're an application developer, analyst, data scientist, or anyone who's had to figure out how to work with relational databases, chances are you're familiar with indexes. At least to the extent that you know they somehow help speed up your queries. (That's where I'd left my understanding of indexes for a good amount of time).

Bruce Momjian: The Inner Workings of Oracle Development

31. August 2020 - 17:00

Having worked in open source for decades, where every success and failure is public knowledge, I have always wondered how proprietary development is done, particularly for databases. I have gotten some glimpses into that world from former employees, but this Y combinator thread is the most extensive view of Oracle development I have ever seen.

Andreas 'ads' Scherbaum: Marco Slot

31. August 2020 - 16:00
PostgreSQL Person of the Week Interview with Marco Slot: I’m originally from a small city by the sea called Den Helder in the Netherlands, but nowadays I live in Haarlem with my wife and cat by a tiny canal.

Amit Khandekar: Need for external compression methods in PostgreSQL

30. August 2020 - 16:58

 Every modern database system has some way to compress its data at some level. The obvious reason for this feature is to reduce the size of it's database, especially in today's world where the data is growing exponentially. The less obvious reason is to improve query performance; the idea is: smaller data size means less data pages to scan, which means lesser disk i/o and faster data access. So, in any case, data de-compression should be fast enough so as not to hamper the query performance, if not improve it.

Tatsuo Ishii: New statistics data in Pgpool-II

30. August 2020 - 8:28


 Upcoming Pgpool-II 4.2 will provide new statistics data such as number of INSERT/DELETE/UPDATE etc.  to you. In this blog I will show you how it will look like.

Yogesh Sharma: Introducing the Postgres Prometheus Adapter

28. August 2020 - 16:56

Prometheus is a popular open source monitoring tool and we have many customers that leverage it when using the Crunchy  PostgreSQL Operator or Crunchy PostgreSQL High Availability.

Michał Mackiewicz: Pitfalls and quirks of logical replication in Postgres 12

28. August 2020 - 14:59

Logical replication, in a nutshell, is a process of “replaying” data changes in another database. The first attempts to implement replication in Postgres – Slony, Bucardo – were logical replication solutions.