Neues vom PostgreSQL Planet

The latest release of PgBouncer 1.22.0 increases query throughput by 15% to 250% and includes support for DEALLOCATE ALL and DISCARD ALL, as well as protocol-level prepared statements released in 1.21.0.

Today we at PeerDB are introducing the ClickHouse target connector in Beta. With this you can seamlessly replicate data in Postgres to ClickHouse with low latency and high throughput. ClickHouse was one of the most asked connector from our customers,...

Learn how DBtune simplifies PostgreSQL parameter tuning and helps in achieving peak performance based on workload.

The post PostgreSQL Tuning and DBtune appeared first on Stormatics.

Dea PostgreSQL Community, friends, and colleagues! The PG Day Chicago schedule is here! I want to thank everybody who submitted proposals and our CfP committee for doing an exceptional job reviewing submissions and finalizing selection in a very short time!

We will have three tracks with twenty-one talks total, plus Lighting talks, and my only regret is that I won’t be able to listen to most of them. But those who are going to attend will have way better chances!

In this blog post, we are going to briefly discuss the reasons why column order matters when creating tables -or relations- in PostgreSQL.AlignmentIn its internal representation of tuples, Postgres will set each column at a position depending on the alignment defined for the data type used (following the same sequential order as the one used […]

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

Table of Contents

• Database fundamentals
  • The Manga Guide to Databases
  • Database Design for Mere Mortals

  • Jan Karremans: The four quadrants of an Oracle migration

    12. Februar 2024 - 8:15
    The missing piece

    When you think about migration from Oracle to Postgres, most people just say that it is easy. And if you consult the various sources of information, nothing tells you differently.
    And it might not even be untrue. Most databases we create, manage, and run are easy to migrate. If you look at the characteristics of these databases, the large bulk of these: