Sammlung von Newsfeeds

Umair Shahid: Enhancing PostgreSQL Performance by Scaling Horizontally using PL/Proxy

Neues vom PostgreSQL Planet - 13. Februar 2024 - 19:10

Discover how PL/Proxy enhances PostgreSQL performance through efficient horizontal scaling. Learn the pros, cons, and best practices for optimizing your database systems.

The post Enhancing PostgreSQL Performance by Scaling Horizontally using PL/Proxy appeared first on Stormatics.

Paul Ramsey: PostGIS Clustering with K-Means

Neues vom PostgreSQL Planet - 13. Februar 2024 - 14:00

Clustering points is a common task for geospatial data analysis, and PostGIS provides several functions for clustering.

Tristen Raab: Deciphering PostgreSQL Encryption: A Beginner’s Guide

Neues vom PostgreSQL Planet - 13. Februar 2024 - 1:12
Introduction

In this blog, we’ll go over the different methods we can use to encrypt and decrypt data in a PostgreSQL database. Having some experience with Linux and PostgreSQL is necessary, while experience with encryption is not but is nice to have. This blog was written using PostgreSQL 16 running on Ubuntu 23.04. First I’ll go over some motivations for encryption and its importance to data security, then look at a subset of the functions offered by PostgreSQL to implement encryption.

Luca Ferrari: Using PL/Java to Return SETOF RECORD

Neues vom PostgreSQL Planet - 13. Februar 2024 - 1:00

A simple way to return multiple records from PL/Java

Using PL/Java to Return SETOF RECORD

PL/Java allows a quite easy implementation of result set providers, objects that will produce rows that can be used as tables in queries. In order to produce a result set, the main steps are: 1) implement the ResultSetProvider interface and its method to effectively produce the data; 2) build a PL/Java function that will instantiate the above ResultsetProvider, so that PL/Java will wrap such function into a RETURN SETOF RECORD SQL function.

Ricardo Zavaleta: Benchmarking PostgreSQL connection poolers: PgBouncer, PgCat and Supavisor

Neues vom PostgreSQL Planet - 13. Februar 2024 - 1:00

Creating a connection to your Postgres database to execute a short-lived query is expensive. Several people have measured the overhead of Postgres connections and some locate them in the range of 1.3MB of memory per connection and others in the range of 2MB.

Vibhor Kumar: Exploiting SQL/JSON Enhancements for Modern Workloads in PostgreSQL 16

Neues vom PostgreSQL Planet - 12. Februar 2024 - 22:56

The latest iteration of PostgreSQL, version 16, brings a suite of enhancements that bolster its capabilities with JSON data. These improvements not only align PostgreSQL more closely with the SQL/JSON standard but also offer significant optimizations that streamline and enhance working with JSON data. This evolution is a testament to PostgreSQL’s commitment to meeting the demands of modern, data-driven applications that leverage semi-structured data for a myriad of use cases.

Gülçin Yıldırım Jelínek: The Builders Podcast Recap: Transcending Tech Challenges and Driving Postgres Progress with Tomas Vondra

Neues vom PostgreSQL Planet - 12. Februar 2024 - 21:34
We’re back with episode two of our new Builders podcast series. In this episode, host Gülçin Yildirim Jelinek, EDB Staff Engineer, and Tomas Vondra, EDB Senior Principal Engineer and PostgreSQL committer, discuss the challenges and adaptability of Postgres and the path for driving progress. They also highlight their favorite extensions and explore the different ways developers can contribute.

Álvaro Hernández: How to Run Metis on Top Of StackGres

Neues vom PostgreSQL Planet - 12. Februar 2024 - 14:00
How To Run Metis On Top Of StackGres

In this how-to guide, we’ll walk you through the whole process of setting up Metis on a Kubernetes cluster using StackGres.

Andrew Dunstan: Review: PostgreSQL 16 Administration Cookbook

Neues vom PostgreSQL Planet - 12. Februar 2024 - 13:51

This book, published in December 2023 by packt, is the latest incarnation of a book originally principally authored by Simon Riggs, and brought up to date for PostgreSQL 16 by my EDB colleagues Gianni Ciolli,  Boriss Mejías, Jimmy Angelakos and Vibhor Kumar. It's available in both hard copy and electronic format. For review purposes, the publisher provided me with one of each. DBAs will probably find the electronic format more useful because of the ability to cut and paste from it.

Andrew Dunstan: Review: PostgreSQL 16 Administration Cookbook

Neues vom PostgreSQL Planet - 12. Februar 2024 - 13:51

This book, published in December 2023 by packt, is the latest incarnation of a book originally principally authored by Simon Riggs, and brought up to date for PostgreSQL 16 by my EDB colleagues Gianni Ciolli,  Boriss Mejías, Jimmy Angelakos and Vibhor Kumar. It's available in both hard copy and electronic format. For review purposes, the publisher provided me with one of each. DBAs will probably find the electronic format more useful because of the ability to cut and paste from it.

Adrien Nayrat: Recommended resources to improve your knowledge of Databases and PostgreSQL

Neues vom PostgreSQL Planet - 12. Februar 2024 - 9:00
Table of Contents

Dian Fay: (Plausible) Random Geography Generation with PostGIS: Fluviation

Neues vom PostgreSQL Planet - 12. Februar 2024 - 1:00

Welcome to Squaria.

Squaria is a continent of highly unstable geography defined by a single SQL query (with, as we'll see, many, many CTEs). Its only consistent properties at the moment are its boxy shape and the two unnervingly straight mountain ranges that cross its breadth and meet on its lower eastern edge. Those mountains are impossible, but today's topic is fluviation, that is, rivers and riverine lakes; we'll see about plausible plate tectonics some other time, maybe.

Ryan Lambert: Hosting a set of Postgres Demo databases

Neues vom PostgreSQL Planet - 10. Februar 2024 - 6:01

In April 2023, I submitted my proposal for a full-day pre-conference at PASS 2023. My chosen topic was focused on PostGIS, titled GIS Data, Queries, and Performance. A key part of my submission was that the session would be an interactive, follow-along type design. Julie and I believe that doing is key to learning so we wanted to enforce that as much as possible.

Luca Ferrari: pgagroal-cli gains JSON output

Neues vom PostgreSQL Planet - 10. Februar 2024 - 1:00

A new feature of pgagroal-cli that now makes another step towards the full automation.

pgagroal-cli gains JSON output

At last, I made it: a commit in pgagroal to support JSON output. It has been quite hard and long, not for the technological challenge, rather for all the little details like continuos integration, to get this work completed. As a rule of thumb, I stated this work last November (of course, slowly working in and out).

David Z: Enhance PostgreSQL TLS Security with OCSP Stapling

Neues vom PostgreSQL Planet - 9. Februar 2024 - 21:41
1. Overview

In my previous blog, I discussed how to quickly set up a TLS connection between a PostgreSQL server and a psql client. In this blog, I will guide you through the process of setting up a TLS connection using OCSP Stapling, which can help improve the security of PostgreSQL.

2. What is OCSP Stapling?

Before diving into how to enable OCSP Stapling with PostgreSQL, we need to understand some basic concepts:

Greg Sabino Mullane: Postgres Not Starting: The Case of the Missing Output

Neues vom PostgreSQL Planet - 9. Februar 2024 - 14:00
Strangely quiet around here

My colleague Bob Pacheco asked me to help with a strange problem he was witnessing for a client. A new Postgres cluster was getting created on a Kubernetes node, but it refused to start.

Stefan Fercot: Back from FOSDEM 2024

Neues vom PostgreSQL Planet - 9. Februar 2024 - 13:17

Everyone knows FOSDEM, right?
The PostgreSQL Project has been present there with a booth and a Devroom since more than 15 years now!
And this year there was the 10th FOSDEM PGDay organized on the Friday before FOSDEM.

I had the chance to spend 3 days with awesome #PostgresFriends and even more free and open source software aficionados.
Here’s a short writing of how I lived those exhausting but very exciting days.

Pavel Stehule: new extension pgmeminfo

Neues vom PostgreSQL Planet - 8. Februar 2024 - 19:19

I wrote very simple extension pgmeminfo for PostgreSQL12+, that should to help with investigation of memory usage by Postgres. Function pgmeminfo returns glibc information about memory usage provided by function mallinfo(). It is much more precious than usage top or htop.

Karen Jex: Learning about "transqlate" at PG Session 16

Neues vom PostgreSQL Planet - 8. Februar 2024 - 18:48

After the craziness of the FOSDEM weekend in Brussels (FOSDEM PGDay, and the PostgreSQL booth and Devroom at FOSDEM itself) I headed to Paris for

Seiten