Sammlung von Newsfeeds
Ari Padilla: Podcast about transitioning from developer to PostgreSQL specialist, with Derk van Veen
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
Francesco Tisiot: 11 Lessons to learn when using NULLs in PostgreSQL®
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
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
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
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.
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 :
Devrim GÜNDÜZ: Installing PostgreSQL on SLES 15 just got easier – and better!
The PostgreSQL RPM repository for SuSE Enterprise Linux has supported SLES for quite some time. We followed the usual conventions and used zypper addrepo … to add the repositories.
Continue reading "Installing PostgreSQL on SLES 15 just got easier – and better!"
Umair Shahid: The default value of fdw_tuple_cost was updated to 0.2. What does that mean?
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
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
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
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
Luca Ferrari: pgagroal 1.6.0 has been released
pgagroal, the fast connection pooler for PostgreSQL, has reached a new stable release!
pgagroal 1.6.0 has been releasedA couple of days ago, pgagroal version 1.6.0 has been released.
cary huang: Multiple Client Certificate Selection – a Simple POC
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
Brian Pace: The Rest is History: Investigations of WAL History Files
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.
David E. Wheeler: Recent PGXN Improvements
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
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.