Sammlung von Newsfeeds

Timescale PostgreSQL Survey

Timescale Inc. is a well known company in the PostgreSQL community, mostly because of their PostgreSQL extension TimescaleDB.

The survey for 2024 is open now until September 30th 2024. If you could spare some time to answer the questions, the community would appreciate it.

The results will be published shortly afer the survey has ended to everyone.

Introduction

Running ANALYZE (either explicitly or via auto-analyze) is very important in order to have uptodate data statistics for the Postgres query planner. In particular after in-place upgrades via pg_upgrade, ANALYZE needs to be run in order to have any query statistics at all. As ANALYZE samples only parts of the blocks in a table its I/O pattern looks more like random access than sequential read.

Let me present another “first patch” idea, related to a runtime stats on access to files storing data. Having this kind of information would be very valuable on instances with many files (which can happen for many reasons).

This is a very different area than the patch idea, which was about an extension. The runtime stats are at the core of the system, and so is the interaction with the file systems. But it’s still fairly isolated, and thus suitable for new contributors.

CloudNativePG is an open-source operator designed to manage PostgreSQL workloads on any supported Kubernetes cluster running in private, public, hybrid, or multi-cloud environments. CloudNativePG adheres to DevOps principles and concepts such as declarative configuration and immutable infrastructure.

The post Deploying Your First PostgreSQL Clusters on Kubernetes with Cloud Native Postgres appeared first on Stormatics.

In this article, I’ll explore how Kubernetes and CloudNativePG can be leveraged to streamline the testing of PostgreSQL patches, especially during a Commitfest. By automating the creation of PostgreSQL container images from any public Git repository, developers and reviewers can quickly and efficiently test patches within a Kubernetes environment. This approach not only saves time but also enhances the reliability of patches before integration into the main codebase.

In this introduction, we will explore the concept of VACUUM in PostgreSQL, its importance, and best practices for implementing effective vacuuming strategies to ensure your database remains efficient, performant, and reliable. Before we dive into strategies, problem detection and so on, it is important to understand why VACUUM is needed in the first place.

I wrote recently about the performance of PostgreSQL when compiled with different compilers and optimization levels. Another dimension in that evaluation is link-time optimization (LTO).

LTO allows the compiler to perform optimizations across source-file boundaries (more correctly, compilation unit boundaries).

Join us for the Postgres Happy Hour in Vienna on September 18th!

• Greg Sabino Mullane analyzed a year’s worth of pgsql-hackers traffic, deciphered the language used on that mailing list, and compiled a jargon file for newcomers: crunchydata.com/blog/understanding-the-postgres-hackers-mailing-list.

These are my least favorite mysteries to resolve. I hate mysteries when it comes to performance problems. A performance mystery means I do not know how to make it work faster! However, I love solving mysteries—except when presented with a “sometimes it is slow” case.

Redgate's State of the Database Landscape Survey is back again in 2024 and ready for your feedback! The 2023 survey gathered insights from nearly 4,000 data professionals about evolving database complexities and skill demands. The 2024 survey will focus on learning, AI, cloud, and security. Participate for insights and a chance to win Amazon vouchers.

PostgreSQL Person of the Week Interview with Amul Sul: I am Amul Sul, and I grew up and completed my university studies in Mumbai. I did my master’s in computer application from VJTI, Mumbai. In 2012, NTT DATA brought me on board through campus placement. For three years, I dived deep into PostgreSQL, working on NTT DATA’s internal PostgreSQL project.