Six Months vs Six Days: The True Cost of Building Internal Tools
This blog is about how CYPEX can cut costs on building internal tools.
Webinar: From Oracle to PostgreSQL: Leave Oracle Behind, Not Your Security Standards
pgwatch v6: dashboards reimagined, and a reaper that doesn't choke
This is an extended blog, and talks about the features of pgwatch v6.0.0 beta in more details. Read to know and contribute.
pgwatch v6: Prometheus becomes a source, not just a sink
This blog explains all feature highlights related to PGWatch 6.0.0 beta. You can read to understand and test the features yourself.
Day to day PostgreSQL on Kubernetes: Resize, Scale, and Upgrade
This blog explains the daily operations of PostgreSQL on Kubernetes, which involves scaling, resizing. Read to have a deep dive.
Highly Available PostgreSQL on Kubernetes in 10 Minutes
This blog post is a walkthrough of High Availability of PostgreSQL in Kubernetes, using PG Operator. Read to know more.
CYBERTEC PG Operator Resources: Docs, Tutorials & Whitepapers
Explore CYBERTEC PG Operator resources, including documentation, tutorials, guides, and technical material for running PostgreSQL on Kubernetes.
PostgreSQL Jobs & Opportunities
Here you can find our actual PostgreSQL Jobs & Opportunities. Check out our current open jobs at CYBERTEC.
Introducing the CYBERTEC PG Operator
CYBERTEC PG Operator is an open-source Kubernetes operator for PostgreSQL, with Multi-site Clusters for cross-site replication and automated failover.
Multi-Region PostgreSQL Disaster Recovery and Failback with Crunchy PGO
This blog talks about Disaster recovery and Failback in PostgreSQL using Crunchy PGO. It has some detailed steps to understand better.
CYBERTEC and Meniko Data Solutions Announce Strategic Partnership
Vienna, Austria / Pretoria, South Africa / Mauritius - 6 August, 2026 CYBERTEC PostgreSQL International GmbH, the world's leading PostgreSQL
Mastering PostgreSQL Configuration Management with CloudNativePG (CNPG)
This blog talks about Configuration Management in PostgreSQL with CNPG, with some great examples in a comprehensive way.
Data Lineage in PostgreSQL 19: Finally, an Answer When the CFO Asks "Where Did This Number Come From?"
This blog explores Data Lineage using SQL/PGQ in PostgreSQL 19, with real life examples that can enhance your learning.
PostgreSQL Events, Conferences & Webinars
Where to find the CYBERTEC team in person. PostgreSQL conferences, fairs, and online webinars, hosted by the engineers behind PGEE, Patroni and pgwatch.
PostgreSQL vs Destructive Time Travel: The Year 2038 Problem
Explore the Year 2038 problem, Unix epoch, integer overflow, and how PostgreSQL handles time beyond 2038 with modern timestamp architecture.
PostgreSQL Insights That Actually Matter
With our newsletter we will inform you about the latest PostgreSQL updates and topics. Subscribe to the CYBERTEC PostgreSQL Newsletter now.
How SQL/PGQ Rewrites to Joins on PostgreSQL 19
This blog post discusses how SQL/PGQ acts as Joins in PostgreSQL 19 with some walkthrough examples and limitations.
Why pg_hardstorage has no incremental chain
This blog explores why pg_hardstorage has no incremental chain and the architecture design of pg_hardstorage.
Too many tables are bad for you
This article shows that problems that too many tables in a single PostgreSQL database can cause and how to deal with these problems.
Heterogeneous Graphs in SQL/PGQ on PostgreSQL 19
This blog explores Heterogeneous Graphs in SQL/PGQ in depth along with some best practices that should be followed to get best results.
On the Role of Key Management in PostgreSQL
Cybertec's PM discusses the importance of key management in PostgreSQL and how open-source customer feedback shapes our TDE solutions.
Compliance
Security and sustainability are our goals. CYBERTEC is ISO and TISAX certified. CYBERTEC is audited on a regular basis.
PGConf.dev 2026 in Vancouver
This blog explores the experience of PGConf Dev 2026, in depth, you can know more about the experience from the blog.
Handling graphs with SQL/PGQ in PostgreSQL
This blog explores Graph relationships in PostgreSQL with PGQ. Read and learn on, how to traverse and create Graph relationship.
When is a function leakproof?
This article discusses row-level security, security barrier functions and leakproof functions, which are necessary to make them work.
From Stream Processing to the "PostgreSQL Village": A Marketer's Journey to PGConf.de
Discover the unique community DNA of PostgreSQL as a former Apache Flink event manager shares insights from PGConf.DE 2026.
The Path to Data Sovereignty: CYBERTEC and SUSE Unite for Open Source
This blog post talks about the partnership between CYBERTEC and SUSE which offers a pre-validated part for users. Read to know more!
Nordic Cool Meets Parisian Chic Vlog: Two PGDays, One Week
This blog talks about the vlog series and the episode showcasing the Nordic Pgday 2026 and pgDayParis. Read to know more.
My queries to monitor autovacuum
This article shows the queries that I use to monitor autovacuum and explains the background and the measures you can take to avoid problems.
CYPEX Online Academy - Application Audit Section
Audit your application in CYPEX - The visual editor allows you to track all changes in a table and quickly see what has changed where.
CYPEX Online Academy - Overview and first application in a few minutes
Produce your first PostgreSQL-based CYPEX application in just a few minutes - see what to do before and after app generation.
CYPEX Use Cases
CYBERTEC's CYPEX makes internal app development with PostgreSQL a breeze. Check out use cases in livestock management and internet shopping!
Close-to-zero-downtime migration from Oracle to PostgreSQL
Close-to-zero-downtime migration is a must - especially true if you want to migrate a large Oracle database to PostgreSQL.
Independence Is Not Just a Database Feature
This blog, talks about CYBERTEC and its initiative for the greener world. Hear from the CEO himself what's more to come.
Compliance for Switzerland
From Legal Briefs to Postgres Beats: My Whirlwind PGConf India Experience
This blog describes the experience of PGConf India 2026, read and know more about the event and what can you expect next.
Patroni: Cascading Replication with Standby Cluster
A demonstration of how to setup a Patroni standby cluster, including prerequisites, configuration and promotion.
Lightbits & CYBERTEC at KubeCon Europe 2026
From MD5 to Scram: The next security shift in PostgreSQL
This blog talks about the security shift in PostgreSQL as MD5 is deprecated with practical examples to showcase the same.
Create your PostgreSQL clusters with the "builtin" C collation!
Read my plea for using the C collation when you create a PostgreSQL database cluster, ideally using the "builtin" collation provider.
PostgreSQL Books
CYBERTEC regularly publishes PostgreSQL books. Keep up-to-date and get an introduction to important new database features of each version.
Phenomenology through PostgreSQL Documentation
This blog talks about PostgreSQL documentation philosophy and how it is connected to Contributors preserving the intent. Read to know more.
Exploration: CNPG Extensions(ImageVolume)
Demonstration of how to install PostgreSQL extensions on a Kubernetes managed cluster by using CNPG and Kubernetes' ImageVolume feature.
Dealing with integer overflow in sequence-generated primary keys
Sequence-generated 4-byte integer primary keys can experience integer overflow. I'll show you how to monitor for the problem and fix it.
Dev Container for pgrx PostgreSQL Extensions: Lessons Learned
This blog describes using pgrx extension of PostgreSQL with a walkthrough for containers. Read in as it is discussed in detail.
Comparing stats! PostgreSQL 18 against 17
This blog compares the stats of PostgreSQL 18 and PostgreSQL17. It is a great read with some common questions answered. Read to know more.
Integrating Custom Storages with pgwatch
This blog talks about integration custom storages with PGwatch, and it also includes a walkthrough. Read to know more.
Super fast aggregations in PostgreSQL 19
This blog talks aggregations in PostgreSQL version 19. Read in, check use cases and learn more about the feature.
PostgreSQL performance: Encrypted vs. unencrypted
This is an analysis to give users a way to compare various PostgreSQL settings and their performance: PostgreSQL v13, PostgreSQL TDE
The bastard DBA from hell
Two little stories from the working life of the bastard DBA from hell, fighting user problems (but mostly users).
PostgreSQL 18: More performance with index skip scans
This blog describes the performance of Indexes in PostgreSQL version 18. You can read more to know how the performance matrix works.
Counting Customers in PostgreSQL
This blog post focuses on realtime methods of counting in PostgreSQL. This includes a use case walkthrough. Read to know more.
A Glimpse of PostgreSQL Conference Europe 2025
This blog describes the experience of PostgreSQL conference Europe, 2025, held in RIGA, Latvia. Read and learn more about the conference.
PostgreSQL Training
Get ahead in PostgreSQL and GIS: On-Site, Online or in your Office. You decide what is best for you and your Team.
The Future of CYBERTEC and PostgreSQL
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.
The Today I Learned @CYBERTEC microblog collection has moved!
Included below are links to our PostgreSQL-related tips and tricks: For all other developer tips related to CSS, Javascript, Docker
Benefits of a DESCending index
The DESC clause in CREATE INDEX is rarely needed. I'll show use cases for descending indexes, including storage efficiency and performance.
Webinar: Cross-Platform Auditing
Exploration: CNPG PostgreSQL Upgrade
This post demonstrates how to perform both minor and major PostgreSQL upgrades in a Kubernetes environment using CNPG.
PostgreSQL 18: A Bird Learning to Fly
This blog highlights the features of PostgreSQL version 18 which was released on 25th September, 2025. Dive in to know more.