Keyset pagination with descending order
This article shows how to use keyset pagination if you want to sort some columns in ascending and others in descending order.
Using AI to generate data structures for PostgreSQL
In this blog I decided to show some insights into what can be done by using AI to generate data structures for PostgreSQL.
Swiss PGDay 2024 and PG conferences in general
Read about my impressions from the Swiss PGDay 2024 and learn why you should attend PostgreSQL conferences yourself.
Making the PostgreSQL visibility map visible
This article explains how to examine the PostgreSQL visibility map and showcases performance improvements added in recent releases.
Foreign keys in PostgreSQL: Circular dependencies
In this blog Hans-Jürgen Schönig would like to tell you more about "Foreign keys and circular dependencies".
Why do I have a slow COMMIT in PostgreSQL?
This article describes the possible reasons for a slow COMMIT in PostgreSQL and discusses what you can to against that.
My trip to Zagreb: DORS/CLUC 2024
Jan Karremans was part of the DORS/CLUC 2024 in Zagreb. Find out what his trip to Zagreb was like and what he learned on site in this post.
Patroni Contributors Meeting 2024 in Munich
Before the pgconf.de, a few contributors to the Patroni project met to discuss the past, present and future of this framework for PostgreSQL HA. Find out more.
PGconf.de 2024 in Munich
I had the pleasure of attending PGConf.de in Munich on April 12, 2024. Here I report on my experiences and insights.
Syslog logging with journald in PostgreSQL
This article explains how to configure syslog logging in PostgreSQL and shows how to view and manage the log with journald.
Migrate to CYPEX
It is very easy to migrate your data with CYPEX. Try it out.
Open source key areas for digital autonomy
The main questtion is: How do you bring free and open source initiatives and something as regulated as the European Union?
TDE: A dive into encrypted data
In this article we will tell you how you can find out, if your TDE works and if files on disk are encrypted.
Running HUGE numbers of migrations
CYBERTEC Migrator allows you to run huge numbers of migrations by cloning definitions and re-running the same process over again.
Kubernetes- and OpenShift- ready migration to PostgreSQL
CYBERTEC Migrator is fully Kubernetes- and OpenShift-ready. We rely on modern container technology, which is perfect for quick deployment.
PostgreSQL to Microsoft Excel via Npgsql
Find out how you can integrate and store the use of data in PostgreSQL from Excel with Npgsql. For all Excel heroes here.
The four quadrants of an Oracle migration
This post aims to discuss the four quadrants from Oracle. Also we will show, how you can save time and money with a migration with CYPEX.
CYPEX Rapid Prototyping
Rapid prototyping builds a user experience from customer feedback instead of trying to work from a spec. Save time and prevent stress.
CYPEX - graphical PostgreSQL app development
CYPEX graphical PostgreSQL app development cuts your development costs by providing customers with instant visual feedback.
High speed data migration: maintaining performance
You are looking for high speed data migration? Tests have shown that CYBERTEC Migrator can reach up to 1.5 GB / second.
Oracle to PostgreSQL: Technical quick guide
This quick-start migration guide show various aspects you need to take into consideration when migrating from Oracle to PostgreSQL.
FOSDEM 2024 in Brussels
I went to FOSDEM 2024 in Brussels. In this post I would like to tell you about my personal impressions concerning this event.
Feature complete migration from oracle to PostgreSQL
CYBERTEC Migrator is a feature-complete migration tool which allows you to facilitate Oracle migrations.
Scalefield - Get a first impression
Scalefield is a product developed by CYBERTEC that allows you to easily host PostgreSQL within your own private cloud.
CYPEX - Have a look inside!
Check out some screenshots and videos to get a first impression on how CYPEX works. CYPEX is a tool for rapid application development.
Postgres.AI bot interview for PGSQL Phriday #015
Pavlo Golub is interviewing postgres.ai chat bot about UUIDs for PGSQL Phriday 015 initiated by Lætitia Avrot
PostgreSQL: Why true Open Source matters
Data oulives applications. Data matters. So does reliable and well maintained software as well. Read more about Open Source benefits.
Cloud Services and Fully Managed Postgres
Cloud services are not a thing to get around. Read more about what you should take in consideration when using Postgres Cloud services.
The 2023 PGconf.EU in Prague
The PGConf.eu took place 2023 in Prague. It was a great time with other CYBERTEC members and of course interesting topics.
Broken foreign keys: how can that happen in PostgreSQL?
Do you have a broken foreign key? This article shows possible causes for broken foreign keys, so that you know what to avoid in the future.
What you should know about PostgreSQL minor upgrades
Read all there is to know about minor upgrade in PostgreSQL: how, why and when to install them, and what if your software vendor forbids it.
PGSQL Phriday #014: Wrapping up!
This post wraps up the PGSQL Phriday #014 event, links the participating authors and articles, and briefly reviews the "submissions".
PGSQL Phriday #014: PostgreSQL Events
Participate in "PGSQL Phriday #014: PostgreSQL Events" blogging event. Post invites you to share your experiences, insights, and favorite moments
PostgreSQL on s390x
I am happy to announce PostgreSQL family is growing again, with the addition of IBM’s z-series architecture, called “s390x” in Debian terms.
Using multiple triggers on the same table in PostgreSQL
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 in PostgreSQL
ERROR: current transaction is aborted, commands ignored until end of transaction block in PostgreSQL: what it means & how to fix this error.
Citus: 7 commonly used advanced SQL tools
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.
Citus: Row store vs. column store in PostgreSQL
Row store vs. column store - what is the best option? Are column stores “always cool”? Find out in the context of PostgreSQL and Citus.
"hired" vs. "fired" - fuzzy search in PostgreSQL
How to implement community open source PostgreSQL to do a fuzzy search & get better results. Find out how to use the fuzzystrmatch extension.
Data locality: Scaling PostgreSQL with Citus intelligently
How to use data locality to increase performance while sharding PostgreSQL data with Citus. What is database locality
Monitoring PostgreSQL replication
How to monitor replication lag in PostgreSQL? What is replication lag? And how to best go about monitoring PostgreSQL replication in general?
Citus: Sharding your first table
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.
Conditional foreign keys and polymorphism in SQL: 4 Methods
How to model conditional foreign keys: 4 methods to transfer a reference to a polymorphic type to SQL. Explore how PostgreSQL features like JSON support and table inheritance can help.
Postgres v16: 14 Cool New Features
Find out what PostgreSQL v16 has to offer, what the top new features will be and why the new postgres is so cool and useful.
Indexing "LIKE" in PostgreSQL and Oracle
How to index LIKE conditions in PostgreSQL and Oracle. Answers the question: Why is LIKE indexing simpler in Oracle? Is it better?
Bulk load performance in PostgreSQL
Compare the performance of bulk load methods in PostgreSQL. Get recommendations for parameter settings to improve performance even more.
Killing performance with PostgreSQL partitioning
Partitioning is not without risk. It might help to handle large quantities of data, but it can also have downsides - learn how to it.
Reproducible builds: a PostgreSQL query optimization example
Learn how to rewrite a query to speed up performance - a practical example where Christoph speeds up a PostgreSQL query by a factor of 27,000
Subqueries and performance in PostgreSQL
This article discusses how subqueries perform in PostgreSQL and how to rewrite queries to improve their performance.
Use HOT, so CLUSTER won't rot in PostgreSQL
How to use HOT updates to maintain the row order established by CLUSTER to get efficient index scans in PostgreSQL.
ERROR: invalid byte sequence - Fix bad encoding in PostgreSQL
Fix ERROR: invalid byte sequence for encoding - Wrong encoding causes data corruption in PostgreSQL. How to fix bad encoding.
PostgreSQL ALTER DEFAULT PRIVILEGES - permissions explained
ALTER DEFAULT PRIVILEGES command for PostgreSQL permissions explained: learn how to use it correctly, know its pitfalls and use cases.
Let’s party and upgrade PostgreSQL and PostGIS together
Learn how to upgrade PostGIS together with PostgreSQL all in one go. Step by step instructions using pg_upgrade.
EXPLAIN (GENERIC_PLAN): New in PostgreSQL 16
This article describes the EXPLAIN option GENERIC_PLAN introduced in PostgreSQL 16, including some examples. Learn about options syntax.
Stored procedures in PostgreSQL: getting started
Learn all about stored procedures in PostgreSQL right here with examples created by a database expert. Includes syntax & tips
PostgreSQL: Finding the current timestamp
How can I find the current timestamp in PostgreSQL? Read more about real time, statement time and transaction time.
Reserve connections in PostgreSQL 16
A brand-new patch in PostgreSQL 16 provides a way to reserve connection slots for non-superusers. Find out the news here!
Transaction ID wraparound: a walk on the wild side
Have you ever seen data corruption from transaction ID wraparound? Avoid PostgreSQL performance problems - read here what causes it.
A unique constraint where NULL conflicts with everything
A cute solution for an unusual request for a unique constraint in PostgreSQL. This blog showcases range data types & exclusion constraints.
Pagination and the problem of the total result count
This article compares pagination methods for PostgreSQL and their performance. Also, avoid displaying the total result count!