Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 46 Minuten

cary huang: Understanding Security Features in PostgreSQL – Part 1

22. Januar 2020 - 21:10
1. Introduction

PostgreSQL is packed with several security features for a database administrator to utilize according to his or her organizational security needs. The word Security is a very broad concept and could refer to completely different procedures and methodology to achieve in different PostgreSQL components. This blog is divided into part 1, 2 and 3 and I will explain the word Security with regards to PostgreSQL version 12.1 and how it is practiced in different areas within the system.

Kaarel Moppel: pgwatch2 v1.7.0 released

22. Januar 2020 - 9:30

It’s been exactly half a year since the last major release of the pgwatch2 Open Source PostgreSQL monitoring tool, and I’m glad to announce that another huge set of useful features and improvements have found their way into the pgwatch2 code repository!

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 13 – Allow vacuum command to process indexes in parallel.

21. Januar 2020 - 19:08
On 20th of January 2020, Amit Kapila committed patch: Allow vacuum command to process indexes in parallel.   This feature allows the vacuum to leverage multiple CPUs in order to process indexes. This enables us to perform index vacuuming and index cleanup with background workers. This adds a PARALLEL option to VACUUM command where the … Continue reading "Waiting for PostgreSQL 13 – Allow vacuum command to process indexes in parallel."

Jonathan Katz: Deploy High-Availability PostgreSQL Clusters on Kubernetes by Example

21. Januar 2020 - 9:35

One of the great things about PostgreSQL is its reliability: it is very stable and typically “just works.” However, there are certain things that can happen in the environment that PostgreSQL is deployed in that can affect its uptime, such as:

Andrew Dunstan: jsonb_set_lax

20. Januar 2020 - 4:14
Recently there were some complaints about the behaviour of the jsonb_set function. Specifically, the complain was that if the value argument of the function is null the result is null. This happens because the function is declared STRICT, like many PostgreSQL functions. STRICT is in fact another way of spelling RETURNS NULL ON NULL INPUT. […]

Jobin Augustine: Upgrading PostgreSQL – Patroni Cluster and Switching from Python 2 to Python 3

17. Januar 2020 - 17:32

Python 2 has officially completed its life as of Jan 1st, 2020 and the Python 2.x branch will not be maintained anymore. You might be seeing repeated notices of deprecation in log files and terminals like:

Claire Giordano: Tips on how to get your conference talk SELECTED

16. Januar 2020 - 15:41

As I get ready for the PgDay San Francisco event that is happening next Tue 21 January—a one-day, single-track Postgres community event at the awesome Swedish American Hall in SF—I’m reflecting a bit on how important the speakers are to developer events. Let’s face it, without speakers, there would be no conference.

Leigh Halliday: Effectively Using Materialized Views in Ruby on Rails

16. Januar 2020 - 10:01
It's every developer's nightmare: SQL queries that get large and unwieldy. This can happen fairly quickly with the addition of multiple joins, a subquery and some complicated filtering logic. I have personally seen queries grow to nearly one hundred lines long in both the financial services and health industries. Luckily Postgres provides two ways to encapsulate large queries: Views and Materialized Views. In this article, we will cover in detail how to utilize both views and materialized views…

Andreas Scherbaum: PostgreSQL @ FOSDEM 2020

16. Januar 2020 - 0:35

Andreas 'ads' Scherbaum

The PostgreSQL Project is present with a booth at FOSDEM ever since 2007. Since 2008 we organize a Devroom, since 2013 we have our own PGDay on the Friday before FOSDEM. This year marks the 8th FOSDEM PGDay.

This blog post presents useful information about the PGDay, the booth and Devroom at FOSDEM.


Continue reading "PostgreSQL @ FOSDEM 2020"

Andreas 'ads' Scherbaum: FOSDEM PGDay 2020 - Call for volunteers

15. Januar 2020 - 12:00

FOSDEM PGDay is looking for volunteers! We rely on you to help us host and run a successful FOSDEM booth and devroom.

The areas covered by volunteers include, but are not limited to:

  • room host (Devroom, Sunday)
  • video host (Devroom, Sunday)
  • door bouncer (Devroom, Sunday)
  • booth volunteers (Saturday, Sunday)

Room volunteers have the advantage that they have a guaranteed place in the devroom during their Sunday shift.

Kaarel Moppel: Tips and tricks to kick-start Postgres year 2020

15. Januar 2020 - 9:00

Quite often when visiting customers or doing trainings, I see that people are quite happy seeing and learning about some little time-saving PostgreSQL tricks, commands or SQL snippets on the screen and they usually ask to slow down and explain or just say “wow, didn’t know you could do that”.

Keith Fiske: How To Simplify pgBouncer Monitoring with pgbouncer_fdw

14. Januar 2020 - 20:30

For connection pooling in PostgreSQL, one of the best and most popular tools out there is PgBouncer. However, monitoring PgBouncer can be challenging due to its use of SHOW commands, which are only available via a special database connection as opposed to making its statistics available via a standard table or view.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 13 – ALTER TABLE … ALTER COLUMN … DROP EXPRESSION

14. Januar 2020 - 15:17
Title: Waiting for PostgreSQL 13 – ALTER TABLE … ALTER COLUMN … DROP EXPRESSION On 14th of January 2020, Peter Eisentraut committed patch: ALTER TABLE ... ALTER COLUMN ... DROP EXPRESSION   Add an ALTER TABLE subcommand for dropping the generated property from a column, per SQL standard.

Vik Fearing: pgDay Paris 2020 - Schedule Announced

13. Januar 2020 - 16:00

The 6th edition of the popular PostgreSQL conference pgDay Paris, a PostgreSQL.Org Recognized Community Conference, will be held on March 26, 2020 in the French capital. All of the talks will be in English.

Registration is open, and the EARLYBIRD discount is going fast so make sure you grab that while you can!

Mark Wong: PDXPUG January 2020 Meetup: Interacting with databases as API’s

11. Januar 2020 - 4:00

2020 January 16 Meeting 6pm-8pm


PSU Business Accelerator
2828 SW Corbett Ave · Portland, OR
Parking is open after 5pm.

Speaker: Alex Theodore

David Z: How to create, test and debug an extension written in C for PostgreSQL

10. Januar 2020 - 19:41
1. Overview

PostgreSQL is one of the most popular free open-source relational database management systems in the world. Other than complies to SQL standard, PostgreSQL also provides a great extensibility which allows users to define their own extensions. With such a great feature, PostgreSQL is not only a database but also an application development platform. In this tutorial, we will go through the entire process about creating an extension, running test against this extension, and debugging the extneson using Eclipse.

David Z: How to build and debug PostgreSQL 12 using latest Eclipse IDE on Ubuntu 18.04

10. Januar 2020 - 19:33
1. Overview

This tutorial provides detailed instructions to help a newbie setup the building and debugging environment with the latest Eclipse IDE for C/C++ Developers for current Postgres 12.1 release on LTS Ubuntu 18.04.

Below is the key requirement.

Andreas 'ads' Scherbaum: FOSDEM PGDay 2020 - Announcement

10. Januar 2020 - 13:28

This year's FOSDEM PGDay once again precedes the main FOSDEM event. It will take place on January 31st, 2020, in the Hilton Brussels Grand Place Hotel.

Registration for the PGDay is open, and a registration is required to attend the Friday conference. The number of seats is limited. Visit the Registration page for your ticket!