Sammlung von Newsfeeds

Andreas 'ads' Scherbaum: Nicolas Payart

Neues vom PostgreSQL Planet - 23. September 2024 - 16:00
PostgreSQL Person of the Week Interview with Nicolas Payart: I live in Brittany, France and work as a Database System Engineer for OVHcloud. My wife, daughters and I live in a house in the countryside with our cats (official and otherwise).

Pavlo Golub: Contributions of w/c 2024-09-16 (week 38)

Neues vom PostgreSQL Planet - 23. September 2024 - 12:08
  • Floor Drees wrote an article, how the Postgres community migrated to Mastodon, and which tools can be used.

  • Elodie Jex (Instagram: elodie.s_art_) designed the three proposals for the PostgreSQL Europe Diversity Task Force, from which one was selected as the final logo.

Stefan Fercot: pgBackRest backups from the standby server

Neues vom PostgreSQL Planet - 23. September 2024 - 10:15

Recently, we’ve received many questions about how to take backups from a standby server using pgBackRest. In this post, I’d like to clarify one of the most frequently asked questions and address a common misconception for new users.

Deepak Mahto: Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 7: pg_maintain Predefined Role for Maintenance.

Neues vom PostgreSQL Planet - 23. September 2024 - 9:15

Welcome to Part 7 of our series exploring the exciting new features anticipated in the official PostgreSQL 17 release. In this series, we delve into newly added features and discuss how they can benefit database developers and migration engineers transitioning to PostgreSQL 17 in future.

In case you missed the earlier parts:

Jeremy Schneider: Kubernetes Requests and Limits for Postgres

Neues vom PostgreSQL Planet - 23. September 2024 - 3:02

As Joe said a few days ago: so many Postgres providers. Aiven, AWS, Azure, Crunchy, DigitalOcean, EDB, GCP, Heroku, Neon, Nile, Oracle, Supabase, Tembo, Timescale, Xata, Yugabyte… I’m sure there’s more I missed. And that’s not even the providers using Postgres underneath services they offer with a different focus than Postgres compatibility.

Luca Ferrari: SQLite3 Vacuum and Autovacuum

Neues vom PostgreSQL Planet - 23. September 2024 - 2:00

Similarly to PostgreSQL, also SQLite3 needs some care…

SQLite3 Vacuum and Autovacuum

Today I discovered, by accident I need to confess, that PostgreSQL is not the only database requiring VACUUM: also SQLite3 does.

Andrew Atkinson: Solid Cache for Rails and PostgreSQL

Neues vom PostgreSQL Planet - 23. September 2024 - 2:00

Solid Cache is a relatively new caching framework that’s available now as a Ruby gem. In the next major version of Ruby on Rails, version 8, it’s becoming the default cache backend.

Solid Cache has a noteworthy difference from alternatives in that it stores cache entries in a relational database and not a memory-based data store like Redis.

In this post, we’ll set up Solid Cache, explore the schema, operations, and discuss some Postgres optimizations to consider.

Gabriele Bartolini: CNPG Playground: A New Learning Environment for Postgres in Kubernetes

Neues vom PostgreSQL Planet - 20. September 2024 - 17:57

Welcome CNPG Playground, a local learning environment for exploring CloudNativePG and PostgreSQL in Kubernetes. Using Docker and Kind, it simulates real-world scenarios, enabling developers and DBAs to experiment with PostgreSQL replication across two clusters. Designed for hands-on learning, CNPG Playground provides an accessible entry point for testing configurations and features, with plans for future enhancements and community collaboration.

Umair Shahid: Transitioning from Oracle to PostgreSQL: Understanding the Concept of Schema

Neues vom PostgreSQL Planet - 19. September 2024 - 17:19

As businesses increasingly move toward open-source technologies, many Oracle Database professionals find themselves needing to work with PostgreSQL, one of the most popular open-source relational database management systems (RDBMS). Although both Oracle and PostgreSQL share many similar concepts, there are fundamental differences in how these systems handle certain database structures, one of which is the schema.

Florent Jardin: Hierarchical data types

Neues vom PostgreSQL Planet - 19. September 2024 - 13:20

The SQL standard defines a set of rules so that database systems can be interchangeable, but there are small singularities in the wild. In this regard, the hierarchyid data type provided by SQL Server is a striking example. If you are switching to PostgreSQL, two solutions are available to you.

A first and simpler solution consists in linking each node to its parent using a new parentid column and applying a foreign key constraint. Another, more complete approach consists in using the ltree extension. This article deals with the latter case.

Sven Klemm: Bridging the Gap Between Compressed and Uncompressed Data in Postgres: Introducing Compression Tuple Filtering

Neues vom PostgreSQL Planet - 18. September 2024 - 15:00

When we introduced columnar compression for Postgres in 2019, our goal was to help developers scale Postgres and efficiently manage growing datasets, such as IoT sensors, financial ticks, product metrics, and even vector data. Compression quickly became a game-changer, saving users significant storage costs and boosting query performance—all while keeping their data in Postgres. With many seeing over 95 % compression rates, the impact was immediate.

Karen Jex: Optimising your Database for Analytics

Neues vom PostgreSQL Planet - 18. September 2024 - 12:06

This post contains the slides and transcript from the talk that I gave at PyCon Italia 2024, and at EuRuKo 2024.

You can also watch the video from PyCon Italia here.

"Elevator Pitch"

Andrew Atkinson: Trying out Solid Queue and Mission Control with PostgreSQL

Neues vom PostgreSQL Planet - 18. September 2024 - 2:00
Why Solid Queue?

Background jobs are used commonly in Ruby on Rails apps to perform any work possible outside of a user request. A classic example is sending an email to a new user, where that doesn’t need to happen synchronously within a request. Thus, a background job framework of some kind helps to keep things consistent.

In the 2010s, Sidekiq seemed to become the most popular choice, usable as a free open source version, or a commercial Pro version. Sidekiq uses Redis to persist the job data.

Elizabeth Garrett Christensen: Window Functions for Data Analysis with Postgres

Neues vom PostgreSQL Planet - 17. September 2024 - 16:00

SQL makes sense when it's working on a single row, or even when it's aggregating across multiple rows. But what happens when you want to compare between rows of something you've already calculated? Or make groups of data and query those? Enter window functions.

Window functions tend to confuse people - but they’re a pretty awesome tool in SQL for data analytics. The best part is that you don’t need charts, fancy BI tools or AI to get some actionable and useful data for your stakeholders. Window functions let you quickly:

Tomas Vondra: [PATCH IDEA] amcheck support for BRIN indexes

Neues vom PostgreSQL Planet - 17. September 2024 - 12:00

Time for yet another “first patch” idea post ;-) This time it’s about BRIN indexes. Postgres has a contrib module called amcheck, meant to check logical consistency of objects (tables and indexes). At the moment the module supports heap relations (i.e. tables) and B-Tree indexes (by far the most commonly used index type).

Cornelia Biacsics: Celebrating Partnerships: Our First Partner Event in Wöllersdorf

Neues vom PostgreSQL Planet - 17. September 2024 - 10:15

To recognize over 20 years of growth, the CYBERTEC team welcomed dozens of partners at the headquarters in Wöllersdorf this month. It was a great opportunity to share knowledge and sync about planning for continued success together.

Andreas 'ads' Scherbaum: Andrew Atkinson

Neues vom PostgreSQL Planet - 16. September 2024 - 16:00
PostgreSQL Person of the Week Interview with Andrew Atkinson: I’m a programmer, dad, and husband, and live with my family in Minneapolis, Minnesota, a northern state in the USA. I’ve worked remotely as a software engineer for more than 15 years at big companies like Microsoft and Groupon, and many small and mid-sized startups, scaling up their platform.

Stefan Fercot: Back from PGDay UK 2024

Neues vom PostgreSQL Planet - 16. September 2024 - 10:00

Last Wednesday (September 11, 2024), PGDay UK took place in London. Some of my colleagues live in the area (or not too far away), so it was a great occasion to spend time together! Since London is also a lovely city to visit, we made sure to leave some time for sightseeing

Regina Obe: PostGIS 3.5.0rc1

Neues vom PostgreSQL Planet - 16. September 2024 - 2:00

The PostGIS Team is pleased to release PostGIS 3.5.0rc1! Best Served with PostgreSQL 17 RC1 and GEOS 3.13.0.

This version requires PostgreSQL 12 - 17, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. SFCGAL 1.4+ is needed to enable postgis_sfcgal support. To take advantage of all SFCGAL features, SFCGAL 1.5 is needed.

Regina Obe: PostGIS 3.5.0beta1

Neues vom PostgreSQL Planet - 16. September 2024 - 2:00

The PostGIS Team is pleased to release PostGIS 3.5.0beta1! Best Served with PostgreSQL 17 RC1 and GEOS 3.13.0.

This version requires PostgreSQL 12 - 17, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. SFCGAL 1.4+ is needed to enable postgis_sfcgal support. To take advantage of all SFCGAL features, SFCGAL 1.5 is needed.

Seiten