Neues vom PostgreSQL Planet

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

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!

Florin Irion: Support for PostgreSQL’s System identifier in Barman

9. Januar 2020 - 10:51
The latest Barman 2.10 release introduces support for the system identifier of a PostgreSQL instance. In this article, I will answer a few questions explaining what a system identifier is and why it is a good thing that Barman uses it. What is the PostgreSQL system identifier? PostgreSQL gives a unique system identifier to every […]

Pavel Golub: PSQL_EDITOR: Fighting with Sublime Text under Windows

9. Januar 2020 - 10:00

This supposed to be just a short TIL entry about PSQL_EDITOR variable. While trying to figure out all possible pitfalls, I’ve decided to write a full blog post. You may skip to the summary though. All tests done on Windows 10 with PostgreSQL 12 installed.

Hubert 'depesz' Lubaczewski: Finally – fixed time calculations for parallel plans in

7. Januar 2020 - 17:36
For very long time plans with parallel execution showed bogus values. Not any more. For example, check this: Now, with new logic, the same plan looks like this: Note fixed times, and modified values in loops column. Hope you like it 🙂

Julien Rouhaud: pg qualstats 2: Global index advisor

6. Januar 2020 - 13:23

Coming up with good index suggestion can be a complex task. It requires knowledge of both application queries and database specificities. Over the year multiple projects tried to solve this problem, one of which being PoWA with the version 3, with the help of pg_qualstats extension. It can give pretty good index suggestion, but it requires to install and configure PoWA, while some users wanted to only have the global index advisor.

Mark Wong: Adventure in programming languages and simple statistics

3. Januar 2020 - 1:38
This is a story about how I found myself trying programming languages. I’ve been running an OLTP type database test (DBT-2, if you’ve heard of it), and noticed the post-processing reporting scripts for analyzing the database test results were running longer than I thought they would. I was running tests on 16 systems at the […]

Hans-Juergen Schoenig: PostgreSQL: You might need to increase max_locks_per_transaction

2. Januar 2020 - 10:00

“out of shared memory”: Some of you might have seen that error message in PostgreSQL already. But what does it really mean, and how can you prevent it? The problem is actually not as obscure as it might seem at first glance. max_locks_per_transaction is the critical configuration parameter you need to use to avoid trouble.

Venkata Nagothi: Cloud Vendor Deep-Dive: PostgreSQL on DigitalOcean

30. Dezember 2019 - 11:45

DigitalOcean is a cloud service provider, more of an IaaS (Infrastructure-as-a-Service) provider which is more suitable for small to medium scale businesses. You can get to know more about DigitalOcean here. What it does is a bit different to other cloud vendors like AWS or Azure and is not heavily global yet, take a look at this video which compares DigitalOcean with AWS. 

Abdul Yadi: Reinforce Data Validation: Prevent Direct Table Modification

26. Dezember 2019 - 13:16

Simple validation for tuple modification (insert/update/delete) is by applying constraints. More complex validation can be forced through trigger which is considered expensive by database experts.

The more efficient approach is by implementing validation in user defined function. Regular users are prevented from writing directly to table by issuing INSERT/UPDATE/DELETE. They must invoke provided function to perform those tasks.

Dimitri Fontaine: pgDay Paris 2019 presentation: How to write SQL queries?

25. Dezember 2019 - 22:15

The videos from pgDay Paris 2019 are online, and they look stunning! If you’ve been to the conference, you will be able to enjoy great memories, and if you’ve not been there, you can now enjoy all the fine content that was recorded there at the Youtube Channel for pgDay.Paris.