82 articles by Hans-Jürgen Schönig.
This blog explains the daily operations of PostgreSQL on Kubernetes, which involves scaling, resizing. Read to have a deep dive.
This blog post is a walkthrough of High Availability of PostgreSQL in Kubernetes, using PG Operator. Read to know more.
CYBERTEC PG Operator is an open-source Kubernetes operator for PostgreSQL, with Multi-site Clusters for cross-site replication and automated failover.
This blog explores Data Lineage using SQL/PGQ in PostgreSQL 19, with real life examples that can enhance your learning.
This blog post discusses how SQL/PGQ acts as Joins in PostgreSQL 19 with some walkthrough examples and limitations.
This blog explores why pg_hardstorage has no incremental chain and the architecture design of pg_hardstorage.
This blog explores Heterogeneous Graphs in SQL/PGQ in depth along with some best practices that should be followed to get best results.
This blog explores Graph relationships in PostgreSQL with PGQ. Read and learn on, how to traverse and create Graph relationship.
This blog, talks about CYBERTEC and its initiative for the greener world. Hear from the CEO himself what's more to come.
This blog talks aggregations in PostgreSQL version 19. Read in, check use cases and learn more about the feature.
This blog describes the performance of Indexes in PostgreSQL version 18. You can read more to know how the performance matrix works.
This blog post focuses on realtime methods of counting in PostgreSQL. This includes a use case walkthrough. Read to know more.
This blog describes what we can expect from CYBERTEC in future. Dive in and hear it for the CEO himself, and know about his thoughts.
This blog lets you test the RETURNING clause with updates in PostgreSQL 18, and allows you to have a look at practical scenario.
Efficiency is always a topic. Therefore, it is important to understand that indexing is the key to success. Read more about indexing vectors.
pgvector is a popular PostgreSQL extension for semantic search, facilitating discussions on AI and related topics.
PostgreSQL enhances search capabilities with extensions like pgvector, enabling advanced semantic search. Find out more in this blog posting.
PostgreSQL powers many applications. In this blog posting you can read more about how to debug database applications effectively.
"PostgreSQL scales" - what does it mean? Find out what 1 trillion rows in Citus is all about in this blog post.
In this blog posting you can read more about one of the fundamental principles in the realm of databases: "Normalization".
People tend to think that a SELECT-operation is always a read. This might look obvious and make sense but does it actually hold true?
We will explore the concept of VACUUM in PostgreSQL, its importance, and best practices for implementing effective vacuuming strategies.
In this blog we are talking about indexes. Speeding up index creation in PostgreSQL is one of the main topic.
In this blog I decided to show some insights into what can be done by using AI to generate data structures for PostgreSQL.
In this blog Hans-Jürgen Schönig would like to tell you more about "Foreign keys and circular dependencies".
Data oulives applications. Data matters. So does reliable and well maintained software as well. Read more about Open Source benefits.
What happens if you deploy many triggers on the very same PostgreSQL table? What order do the multiple triggers fire in?
ERROR: current transaction is aborted, commands ignored until end of transaction block in PostgreSQL: what it means & how to fix this error.
How to use 6 commonly-needed SQL tools in Citus. When you run advanced SQL in Citus, what's possible? What SQL statements work? Find out.
Row store vs. column store - what is the best option? Are column stores “always cool”? Find out in the context of PostgreSQL and Citus.
How to implement community open source PostgreSQL to do a fuzzy search & get better results. Find out how to use the fuzzystrmatch extension.
How to use data locality to increase performance while sharding PostgreSQL data with Citus. What is database locality
How to monitor replication lag in PostgreSQL? What is replication lag? And how to best go about monitoring PostgreSQL replication in general?
Here’s how to shard a table from scratch with Citus. Scale PostgreSQL DBs using a sharding approach. How to run a Citus Docker container.
Partitioning is not without risk. It might help to handle large quantities of data, but it can also have downsides - learn how to it.
Learn all about stored procedures in PostgreSQL right here with examples created by a database expert. Includes syntax & tips
How can I find the current timestamp in PostgreSQL? Read more about real time, statement time and transaction time.
Find out how JSON logs can be configured in PostgreSQL 15 and get all the advantages of this brand new feature
When partitioning in PostgreSQL, it's not obvious how to find the location of data afterwards. Here's some great partition tips and tricks.
How do you index in a data warehouse? See the advantages and disadvantages of btree (AKA B-tree) and BRIN indexes in PostgreSQL.
Connections are not free. Conserve your resources - find out about connection pooling in PostgreSQL with pgbouncer.
Did you ever wonder why VACUUM does not shrink PostgreSQL data files? Learn all the most useful secrets of VACUUM.
If 1000's of users constantly poll the database, a lot of load is caused for no benefit. LISTEN / NOTIFY is a better way, find out how.
What's the problem with using PostgreSQL database side sequences to create unique invoice numbers to send to clients? Let's find out.
Joins: Learn how to use an inner join and an outer join in PostgreSQL today by reading our tutorial. Also covers semi and full joins.
Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables
Learn how to address the issue of bonus programs in SQL, improve your understanding of PostgreSQL, and calculate bonus points efficiently
Merge - UPDATED 2023 - a technical preview of how to merge lists with ease. Find out about a wonderful command - add power to your PostgreSQL.
Oracle to PostgreSQL migration - Lessons learned in building a migration tool. How to avoid errors, null bytes and broken content.
zheap has been designed as a new storage engine to handle UPDATE in PostgreSQL more efficiently. Read about the current status and more.
The LIMIT/OFFSET clause is off standard and thus not portable. Read about the proper way to handle it by using “SELECT … FETCH FIRST ROWS”.
Constraints over multiple rows: How to cope with complex PostgreSQL constraints. Advanced techniques - enforce integrity; manage concurrency.
A “materialized view” is an integral feature of every advanced database system. How can you make use of materialized views in PostgreSQL?
Did you know PostgreSQL has the ability to synchronize sequential scans? If you are running data warehouses, you might have already used it without knowing.
This article is about bulk loading, which is the quickest way to import large amounts of data into a PostgreSQL database.
UPDATED Mar 2023: How to use pg_stat_statements to detect slow queries - including examples and code - improve PostgreSQL performance
This tutorial will show you how to setup up and configure streaming replication for PostgreSQL 13 & how to set up database servers quickly.
"ERROR: deadlock detected" - message - what should I do? This article explains what this really means and how deadlocks can be prevented.
Basically, there are two ways to delete BLOBs (binary large objects):Change the PostgreSQL configuration or delete the BLOBs in chunks.
Visualizing spatial data is an important task. This tutorial helps you with getting started with visualizing OSM data with PostGIS and QGIS.