Neues vom PostgreSQL Planet

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

Vik Fearing: pgDay Paris 2020 - Interview with Fabrice Vaillant

27. Februar 2020 - 11:00

Read our interview with Fabrice Vaillant who will talk about going From a Legacy Relational DB to an Event Queue.

Semab Tariq: How to use the SVM Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 2)

27. Februar 2020 - 10:54
This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In this article, we’ll use example of Animals to predict whether they are Mammals, Birds, Fish or Insects. Software versions We’re going to use 2UDA version 11.6-1 to implement the Machine Learning model. This version 11.6-1 combines: PostgreSQL 11.6 Orange […]

Paul Ramsey: PostGIS Day in STL

27. Februar 2020 - 9:00

Every year, on the second Wednesday of November, Esri (“the Microsoft of GIS”) promotes a day of celebration, “GIS Day” in which the members of our community unite to tell the world about the wonders of cartography and spatial data and incidentally use their software a lot in the process.

Vik Fearing: pgDay Paris 2020 - Interview with Daniel Vérité

26. Februar 2020 - 11:00

Read our interview with Daniel Vérité who will talk about Staying Safe from ACID Rains.

Muhammad Usama: Setting up SSL certificate authentication with Pgpool-II

25. Februar 2020 - 13:43

Version 4.0 of Pgpool-II added some very exciting security and authentication features to make it more relevant and useful for enterprise environments. It adds support for providing encrypted passwords in pool_passwd and configuration files and lets the administrators chose different authentication methods to be used for the Client<–>Pgpool-II and Pgpool-II<–>PostgreSQL authentications.

Florian Nadler: Visualizing OSM data in QGIS

25. Februar 2020 - 11:30

Last time we imported OpenStreetMap datasets from Iceland to PostGIS.
To quickly visualize our results, we will now use QGIS to render our datasets and generate some nice maps on the client.

Let’s start with our prerequisites:

Vik Fearing: pgDay Paris 2020 - Interview with Christophe Pettus

25. Februar 2020 - 11:00

Read our interview with Christophe Pettus who will talk about Database Disasters and How to Find Them.

Mark Wong: Creating a PostgreSQL procedural language – Part 3 – Executing User Code

25. Februar 2020 - 1:24
A PostgreSQL procedural language handler needs to look up the body of the user defined function or stored procedure for the code to execute.  Remember that the C function executed to handle PL/Julia user defined functions and stored procedures is defined in the SQL file. Thus the pljulia_call_handler() function needs to be updated to retrieve […]

Luca Ferrari: Usage of disk space in Oracle and PostgreSQL: a simple use case

24. Februar 2020 - 1:00

A very non-scientific comparison about the two database engines.

movead li: Have An Eye On Locks Of PostgreSQL

21. Februar 2020 - 2:32

The lock is an essential part of a database system. In PostgreSQL, there are various locks, such as table lock, row lock, page lock, transaction lock, advisory lock, etc. Some of these locks are automatically added to complete the database functions during the operation of the database system, and some are manually added for the elements in PostgreSQL through some SQL commands. This blog explores the locks in PostgreSQL.

Andreas 'ads' Scherbaum: Postgresql Person of the Week

20. Februar 2020 - 18:54
This website will publish interviews with people who make the PostgreSQL Project what it is today.

Andreas 'ads' Scherbaum: PGConf.DE 2020 - Registration open

20. Februar 2020 - 14:00

PostgreSQL Conference Germany 2020 in Stuttgart, Germany, on May 15th is now open for registrations.

The Call for Papers is already closed, and we are working with the last speakers to confirm their talks, and we will have a full schedule published soon.

There are still a few "EARLYBIRD" tickets available, until end of February.

See you in Stuttgart!

Magnus Hagander: Connecting to Azure PostgreSQL with libpq 12 in a Kerberos environment

20. Februar 2020 - 11:26

If you are using Azure PostgreSQL and have upgraded your client side libpq to version 12 (which can happen automatically for example if you use the PostgreSQL apt repositories), you may see connection attempts fail with symptoms like:

Darafei Praliaskouski: PostGIS 3.0.1

20. Februar 2020 - 1:00

The PostGIS Team is pleased to release PostGIS 3.0.1.

Best served with PostgreSQL 12.2, GEOS 3.8.0, SFCGAL 1.3.7, GDAL 3.0.4, PROJ 6.3.1, protobuf-c 1.3.3, json-c 0.13.1.

Continue Reading by clicking title hyperlink ..

Amit Kapila: Parallelism, what next?

19. Februar 2020 - 12:07
This blog post is about the journey of parallelism in PostgreSQL till now and what is in store for the future.  Since PostgreSQL 9.6 where the first feature of parallel query has arrived, each release improves it.  Below is a brief overview of the parallel query features added in each release.

PG9.6 has added Parallel execution of sequential scans, joins, and aggregates.

Hans-Juergen Schoenig: shared_buffers: Looking into the PostgreSQL I/O cache

19. Februar 2020 - 9:00

The PostgreSQL caching system has always been a bit of a miracle to many people and many have asked me during consulting or training sessions: How can I figure out what the PostgreSQL I/O cache really contains? What is in shared buffers and how can one figure out? This post will answer this kind of question and we will dive into the PostgreSQL cache.

Creating a simple sample database

Before we can inspect shared buffers we have to create a little database. Without data the stuff we are going to do is not too useful:

Hubert 'depesz' Lubaczewski: Why I’m not fan of uuid datatype

19. Februar 2020 - 8:37
Recently, on irc, there were couple of cases where someone wanted to use uuid as datatype for their primary key. I opposed, and tried to explain, but IRC doesn't really allow for longer texts, so figured I'll write a blogpost. First problem – UUID values are completely opaque. That means – uuids generated for table … Continue reading "Why I’m not fan of uuid datatype"

Hubert 'depesz' Lubaczewski: Fix for displaying aggregates on

18. Februar 2020 - 17:41
Couple of days ago RhodiumToad reported, on irc, a bug in Specifically – if explain was done using JSON/XML/YAML formats, and node type was Aggregate, the site didn't extract full info. In text explains the node type is one of: Aggregate HashAggregate GroupAggregate But in non-text formats, type of Aggregate was ignored. As of … Continue reading "Fix for displaying aggregates on"

Hubert 'depesz' Lubaczewski: Which tables should be auto vacuumed or auto analyzed – UPDATE

18. Februar 2020 - 13:45
Some time ago I wrote blogpost which showed how to list tables that should be autovacuumed or autoanalyzed. Query in there had one important problem – it didn't take into account per-table settings.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 13 – Add %x to default PROMPT1 and PROMPT2 in psql

17. Februar 2020 - 21:07
On 12nd of February 2020, Michael Paquier committed patch: Add %x to default PROMPT1 and PROMPT2 in psql   %d can be used to track if the current connection is in a transaction block or not, and adding it by default to the prompt has the advantage to not need a modification of .psqlrc, something … Continue reading "Waiting for PostgreSQL 13 – Add %x to default PROMPT1 and PROMPT2 in psql"