credativ® Blog

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

Categories
Category
Tags
×

Categories

Tags

Tag: planetpostgresql

26 March 2024

Bloat of internal tables due to frequently created and dropped relations

Overview Tables that are created and dropped on demand, whether they are temporary or regular, are frequently used by application developers in PostgreSQL to simplify the implementation of various functionalities and to expedite responses. Numerous articles on the internet describe the advantages of using such tables for storing search results, precalculating figures for reports, importing […]

Read more

22 February 2024

Quick Benchmark: PostgreSQL 2024Q1 Release Performance Improvements

The PostgreSQL 2024Q1 back-branch releases 16.2, 15.6, 14.11, 13.14 and 12.18 on February 8th 2024. Besides fixing a security issue (CVE-2024-0985) and the usual bugs, they are somewhat unique in that they address two performance problems by backporting fixes already introduced into the master branch before. In this blog post, we describe two quick benchmarks […]

Read more

05 May 2022

Moodle PostgreSQL load balancing with HAProxy and Patroni

Moodle is a popular Open Source online learning platform. Especially since the beginning of the COVID-19 pandemic the importance of Moodle for schools and universities has further increased. In some states in Germany all schools had to switch to Moodle and other platforms like BigBlueButton in the course of a few days. This leads to […]

Read more

08 March 2022

SQLreduce: Reduce verbose SQL queries to minimal examples

SQLreduce: Reduce verbose SQL queries to minimal examples Developers often face very large SQL queries that raise some errors. SQLreduce is a tool to reduce that complexity to a minimal query. SQLsmith generates random SQL queries SQLsmith is a tool that generates random SQL queries and runs them against a PostgreSQL server (and other DBMS […]

Read more