credativ® Blog

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

Categories
Category
Tags
×

Categories

Tags

Beiträge von: Josef Machytka
JM

About the author

Josef Machytka

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

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

20 September 2024

The Art and Science of AI Prompt Engineering

Artificial Intelligence (AI) is often regarded as a groundbreaking innovation of the modern era, yet its roots extend much further back than many realize. In 1943, neuroscientist Warren McCulloch and logician Walter Pitts proposed the first computational model of a neuron. The term “Artificial Intelligence” was coined in 1956. The subsequent creation of the Perceptron […]

Read more

23 July 2024

Swiss PG Day 2024

On Thursday, 27 June, and Friday, 28 June 2024, I had the amazing opportunity to attend Swiss PGDay 2024. The conference was held at the OST Eastern Switzerland University of Applied Sciences, Campus Rapperswil, which is beautifully situated on the banks of Lake Zurich in a nice, green environment. With approximately 110 attendees, the event […]

Read more