
Discover how PostgreSQL GPU acceleration with CYBERTEC PGEE GPU speeds up large analytical queries while preserving PostgreSQL’s transaction correctness. Learn how GPU execution supports industrial data analytics and machine learning workflows.
HS
Hans-Jürgen Schönig·October 27, 2026Databases 
Discover how CYBERTEC PGEE GPU brings GPU acceleration to PostgreSQL. Learn how the query planner selects the right execution path, how PostgreSQL maintains transaction correctness, and how GPU-resident data supports high-performance analytics and machine learning workflows.
HS
Hans-Jürgen Schönig·October 23, 2026Databases 
This blog talks about the launch of PGEE GPU. Read about how the usage of PostgreSQL can get faster with using PGEE GPU.
HS
Hans-Jürgen Schönig·October 20, 2026Databases 
This blog explains the daily operations of PostgreSQL on Kubernetes, which involves scaling, resizing. Read to have a deep dive.
HS
Hans-Jürgen Schönig·August 25, 2026Databases 
This blog post is a walkthrough of High Availability of PostgreSQL in Kubernetes, using PG Operator. Read to know more.
HS
Hans-Jürgen Schönig·August 18, 2026Databases 
CYBERTEC PG Operator is an open-source Kubernetes operator for PostgreSQL, with Multi-site Clusters for cross-site replication and automated failover.
HS
Hans-Jürgen Schönig·August 12, 2026Databases 
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.
HS
Hans-Jürgen Schönig·April 21, 2026Databases 
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.
HS
Hans-Jürgen Schönig·October 28, 2025Databases 
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.
HS
Hans-Jürgen Schönig·April 15, 2025Databases 
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.
HS
Hans-Jürgen Schönig·March 27, 2025Databases 
PostgreSQL powers many applications. In this blog posting you can read more about how to debug database applications effectively.
HS
Hans-Jürgen Schönig·March 18, 2025Databases 
"PostgreSQL scales" - what does it mean? Find out what 1 trillion rows in Citus is all about in this blog post.
HS
Hans-Jürgen Schönig·March 13, 2025Databases 
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?

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.
HS
Hans-Jürgen Schönig·January 23, 2024Databases 
What happens if you deploy many triggers on the very same PostgreSQL table? What order do the multiple triggers fire in?
HS
Hans-Jürgen Schönig·November 7, 2023Databases 
ERROR: current transaction is aborted, commands ignored until end of transaction block in PostgreSQL: what it means & how to fix this error.
HS
Hans-Jürgen Schönig·October 27, 2023Databases 
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.
HS
Hans-Jürgen Schönig·September 21, 2023Databases 
Row store vs. column store - what is the best option? Are column stores “always cool”? Find out in the context of PostgreSQL and Citus.
HS
Hans-Jürgen Schönig·September 19, 2023Databases 
How to implement community open source PostgreSQL to do a fuzzy search & get better results. Find out how to use the fuzzystrmatch extension.
HS
Hans-Jürgen Schönig·September 15, 2023Databases 
How to use data locality to increase performance while sharding PostgreSQL data with Citus. What is database locality
HS
Hans-Jürgen Schönig·September 13, 2023Databases 
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
HS
Hans-Jürgen Schönig·February 28, 2023Databases 
How can I find the current timestamp in PostgreSQL? Read more about real time, statement time and transaction time.
HS
Hans-Jürgen Schönig·February 14, 2023Databases 
Find out how JSON logs can be configured in PostgreSQL 15 and get all the advantages of this brand new feature

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.
HS
Hans-Jürgen Schönig·October 11, 2022Databases 
Did you ever wonder why VACUUM does not shrink PostgreSQL data files? Learn all the most useful secrets of VACUUM.
HS
Hans-Jürgen Schönig·October 4, 2022Databases 
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.
HS
Hans-Jürgen Schönig·September 27, 2022Databases 
What's the problem with using PostgreSQL database side sequences to create unique invoice numbers to send to clients? Let's find out.
HS
Hans-Jürgen Schönig·September 20, 2022Databases 
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.
HS
Hans-Jürgen Schönig·September 13, 2022Databases 
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.
HS
Hans-Jürgen Schönig·September 22, 2021Databases 
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.

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.
HS
Hans-Jürgen Schönig·April 27, 2021Databases 
Basically, there are two ways to delete BLOBs (binary large objects):Change the PostgreSQL configuration or delete the BLOBs in chunks.
HS
Hans-Jürgen Schönig·April 13, 2021Databases 
Visualizing spatial data is an important task. This tutorial helps you with getting started with visualizing OSM data with PostGIS and QGIS.

PostgreSQL allows you to define users (=roles), groups, etc. This post explains how to retrieve information on roles & role membership.

Get insight into how the PostgreSQL optimizer works and how it speeds up queries. Find out about anti-join & from_collapse_limit.