credativ® Blog
Here you will find interesting news about industry-specific topics and us.
Categories
Category
04 December 2024
Unique Constraint Violations During Inserts Cause Bloat in PostgreSQL
The issue of table and index bloat due to failed inserts on unique constraints is well known and has been discussed in various articles across the internet. However, these discussions sometimes lack a clear, practical example with measurements to illustrate the impact. And despite the familiarity of this issue, we still frequently see this design […]
28 November 2024
Extended Support of End-of-Life Linux Distributions
Having a Build Infrastructure for Extended Support of End-of-Life Linux Distributions Intro When it comes to providing extended support for end-of-life (EOL) Linux distributions, the traditional method of building packages from source may getting certain challenges. One of the biggest challenges is the need for individual developers to install build dependencies on their own build […]
24 November 2024
Open Build Service - Utility to build and publish updated packages of an EOL distribution
Introduction When it comes to providing extended support for end-of-life (EOL) Linux distributions, the traditional method of building packages from sources may present certain challenges. One of the biggest challenges is the need for individual developers to install build dependencies on their own build environments. This often leads to different build dependencies being installed, resulting […]
15 October 2024
TOASTed JSONB data in PostgreSQL: performance tests of different compression algorithms
TOAST (The Oversized Attribute Storage Technique) is PostgreSQL‘s mechanism for handling large data objects that exceed the 8KB data page limit. Introduced in PostgreSQL 7.1, TOAST is an improved version of the out-of-line storage mechanism used in Oracle databases for handling large objects (LOBs). Both databases store variable-length data either inline within the table or […]
11 October 2024
Migrating from Redis to Valkey: A Guide to the Future of In-Memory Key-Value Databases
Introduction Redis is a widely popular in-memory key-value high-performance database, which can also be used as a cache and message broker. It has been a go-to choice for many due to its performance and versatility. Many cloud providers offer Redis-based solutions: Amazon Web Services (AWS) – Amazon ElastiCache for Redis Microsoft Azure – Azure Cache […]
