Sammlung von Newsfeeds

Ari Padilla: Podcast about transitioning from developer to PostgreSQL specialist, with Derk van Veen

Neues vom PostgreSQL Planet - 28. Februar 2024 - 19:07

How do you feel when your day doesn’t go as planned? In this episode of the Path To Citus Con, the podcast for developers who love Postgres, guest Derk van Veen joins co-hosts Claire Giordano and Pino de Candia to talk about his journey from Java developer to Postgres specialist.

Tobias Petry: First Row of Many Similar Ones

Neues vom PostgreSQL Planet - 28. Februar 2024 - 15:28
SQL is a straightforward and expressive language, but it sometimes lacks constructs for writing queries in a simple way. It's more complicated than it should be to write a query to get, e.g., only the most expensive order for every customer of the current fiscal year. You can use PostgreSQL's vendor-specific DISTINCT ON feature or window functions for every other database - like MySQL.

Francesco Tisiot: 11 Lessons to learn when using NULLs in PostgreSQL®

Neues vom PostgreSQL Planet - 28. Februar 2024 - 11:00

A boolean value should only contain two values, True or False, but is it correct? Usually people assume so, but sometimes miss the fact that there could be the absence of the value all-together. In databases this is absence is usually stored as NULL and this blog showcases how to find them, use them properly and 11 lessons to learn to be a NULL Pro!

Keep in mind, it's not only booleans that can contain NULL values, it's all the columns where you don't define a NOT NULL constraint!

Gabriele Bartolini: Maximizing Microservice Databases with Kubernetes, Postgres, and CloudNativePG

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

Explore the synergy between PostgreSQL and Kubernetes through CloudNativePG — a transformative operator discussed in this article. Discover how this powerful open source stack empowers organizations to free themselves from vendor lock-in and to create a seamless microservice database environment, enhancing innovation, operational efficiency and velocity. This article provides a refreshed perspective on “ Why Run Postgres in Kubernetes?” from 2022.

David Wheeler: Extension Ecosystem Summit 2024

Neues vom PostgreSQL Planet - 27. Februar 2024 - 18:46

I’m pleased to announce that some pals and I have organized and will host the (first annual?) Extension Ecosystem Summit at PGConf.dev in Vancouver (and more, see below) on May 28:

Akhil Reddy Banappagari: AUTOCOMMIT – Oracle vs PostgreSQL

Neues vom PostgreSQL Planet - 27. Februar 2024 - 17:30

Oracle and PostgreSQL differ significantly in their transaction models, and AUTOCOMMIT is one of those differences. We see many of our customers successfully migrate code, but still encounter variations in behavior and even runtime errors related to transaction control. Many issues happen because AUTOCOMMIT settings differ between Oracle and PostgreSQL. It is definitely necessary to […]

Deepak Mahto: Uncovering and Exploring ROW Constructors in PostgreSQL.

Neues vom PostgreSQL Planet - 27. Februar 2024 - 14:55

A ROW expression allows you to construct ROW values, which can represent anonymous records, specific table row types, or custom composite types. Its uses include processing records within multiple expressions (using operators like =, <>, <, <=, >, or >=), evaluation with subqueries, and combining ROW values to build composite types. You can even export these to JSON format (using functions like rowtojson). Some key operations you can perform with a ROW constructor in Conversion or migration are :

Umair Shahid: The default value of fdw_tuple_cost was updated to 0.2. What does that mean?

Neues vom PostgreSQL Planet - 27. Februar 2024 - 14:14

This blog post explores the recent change to the fdw_tuple_cost parameter in PostgreSQL, examining the problem it addresses and the reasoning behind the new default value (0.2).

The post The default value of fdw_tuple_cost was updated to 0.2. What does that mean? appeared first on Stormatics.

David Wheeler: Extension Ecosystem Summit 2024

Neues vom PostgreSQL Planet - 27. Februar 2024 - 1:36

I’m pleased to announce that some pals and I have organized and will host the (first annual?) Extension Ecosystem Summit at PGConf.dev in Vancouver (and more, see below) on May 28:

semab tariq: Understanding Indexes in pgvector

Neues vom PostgreSQL Planet - 26. Februar 2024 - 14:26

Explore how pgvector's indexes work, choose the right one for your needs, and find the best option for your critical data.

The post Understanding Indexes in pgvector appeared first on Stormatics.

Anthony Sotolongo León: TOAST and its influences on parallelism in PostgreSQL

Neues vom PostgreSQL Planet - 26. Februar 2024 - 11:00
Introduction

Since the PostgreSQL 9.6 version was released, the feature related to query parallelism has appeared and has become a good option to improve query performance. Since then, the evolution of parallelism has been growing, resulting in better performance in the database. To manage the behavior of parallelism, there are some parameters that you can tune, for example:

Shayon Mukherjee: 100x Faster Query in Aurora Postgres with a lower random_page_cost

Neues vom PostgreSQL Planet - 24. Februar 2024 - 7:43
Recently I have been working with some queries in Postgres where I noticed either it has decided not to use an index and perform a sequential scan, or it decided to use an alternative index over a composite partial index. This was quite puzzling, especially when you know there are indexes in the system that can perform these queries faster. So what gives? After some research, I stumbled upon random_page_cost (ref).

Luca Ferrari: pgagroal 1.6.0 has been released

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

pgagroal, the fast connection pooler for PostgreSQL, has reached a new stable release!

pgagroal 1.6.0 has been released

A couple of days ago, pgagroal version 1.6.0 has been released.

cary huang: Multiple Client Certificate Selection – a Simple POC

Neues vom PostgreSQL Planet - 24. Februar 2024 - 0:13
Introduction

I recently came across this email thread discussion from several years ago, which discussed ways to enable a client to choose from a list of client certificates to send to the server. The benefit is obvious; when a client has to communicate with different PostgreSQL servers with different TLS settings and trust structure, the feature can help reduce the application’s effort to figure out what certificate to send to what server.

Ryan Booz: Changes to PGSQL Phriday Blogging Events

Neues vom PostgreSQL Planet - 23. Februar 2024 - 22:54
It’s been great to see the interest and participation of the monthly PGSQL Phriday blogging event grow over the last 15 months. And like any new venture, it takes time to see and understand the best way to organize it and what the best parameters are to encourage more participation from month to month. With ... Read more

Brian Pace: The Rest is History: Investigations of WAL History Files

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

PostgreSQL uses the concept of a timeline to identify a series of WAL records in space and time. Each timeline is identified by a number, a decimal in some places, hexadecimal in others. Each time a database is recovered using point in time recovery and sometimes during standby/replica promotion, a new timeline is generated.

Raouf Chebri: Autoscaling in Action: Postgres Load Testing with pgbench

Neues vom PostgreSQL Planet - 23. Februar 2024 - 10:25

In this article, I’ll show Neon autoscaling in action by running a load test using one of Postgres’ most popular benchmarking tool, pgbench. The test simulates 30 clients running a heavy query.

David E. Wheeler: Recent PGXN Improvements

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

One of the perks of my new gig at Tembo is that I have more time to work on PGXN. In the last ten years I’ve had very little time to give, so things have stagnated. The API, for example, hasn’t seen a meaningful update since 2016!

But that’s all changed now, and every bit of the PGXN architecture has experienced a fair bit of TLC in the last few weeks. A quick review.

David Wheeler: The History and Future of Extension Versioning

Neues vom PostgreSQL Planet - 22. Februar 2024 - 20:33

Every software distribution system deals with versioning. Early in the design of PGXN, I decided to require semantic versions (SemVer), a clearly-defined and widely-adopted version standard, even in its pre-1.0 specification.

Seiten