credativ® Blog

Here you will find interesting news about industry-specific topics and us.

Categories
Category
Tags
×

Categories

Tags

17 December 2024

Quick Benchmark: Improvements to Large Object Dumping in Postgres 17

Version 17 of PostgreSQL has been released for a while. One of the many features is a change by Tom Lane called “Rearrange pg_dump’s handling of large objects for better efficiency”. In the past, we have seen our customers have several problems with a large number of large objects being a performance issue for dump/restore. […]

Read more

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 […]

Read more

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 […]

Read more

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 […]

Read more

08 October 2024

Different aspects of AI hallucinations: factual errors vs creativity

The topic of AI “hallucinations” has gained considerable attention in discussions surrounding large language models (LLMs) and generative AI. Some view it as the most significant flaw of LLMs, undermining their usability. Yet others see it as a potential source of new ideas. Let us delve deeper into this issue. To understand this phenomenon, it is […]

Read more