Practical Examples of Data Normalization in PostgreSQL

Normalization by Osmosis Part 2: Practical Examples of Data Normalization in PostgreSQL Having gone through a theoretical introduction in part 1, it is now time to discuss some more practical examples. I’ll first talk about the… type modeling … of columns. It is important to realize that during the time Codd formulated the base 3 […]

Read more

Data Normalization in PostgreSQL

Normalization by Osmosis Part 1: A Guide to Data Normalization in PostgreSQL  By Michał Małecki Introduction Although I installed my first PostgreSQL database on RedHat Linux (not RHEL) 6.0 around 1999, I probably limited my interaction with this 6.5 release to starting the server with SysinitV scripts. PostgreSQL was at that time an underdog to […]

Read more

pg_rewrite: PostgreSQL Table Partitioning

PostgreSQL table partitioning is by far one of the most popular new PostgreSQL features. Many people look to partitioned tables as a way to improve performance and broaden scalability. However, partitioning comes with a little problem: How can you partition an existing table without locking up the database? The answer is: pg_rewrite can help you […]

Read more

WITH HOLD cursors and transactions in PostgreSQL

© Laurenz Albe 2021 Both cursors and transactions are basic ingredients for developing a database application. This article describes how cursors and transactions interact and how WITH HOLD can work around their limitations. We will also see the dangers involved and how to properly use WITH HOLD cursors in a PL/pgSQL procedure. Cursors in PostgreSQL […]

Read more

Gaps in sequences in PostgreSQL

© Laurenz Albe 2021 Most database tables have an artificial numeric primary key, and that number is usually generated automatically using a sequence. I wrote about auto-generated primary keys in some detail in a previous article. Occasionally, gaps in these primary key sequences can occur – which might come as a surprise to you. This […]

Read more

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. Conveniently scale your deployments and ensure round-the-clock reliability of your databases. CYBERTEC’s Kubernetes- and OpenShift- ready migration to PostgreSQL means your enterprise is ahead of the game before others have even lined up at the […]

Read more

Feature complete migration from oracle to PostgreSQL

Migrate from Oracle with ease CYBERTEC Migrator is a feature-complete migration tool which allows you to facilitate Oracle migrations. As an enterprise-ready product, it focuses explicitly on providing the richest feature set possible. With years of successful migrations behind us, CYBERTEC has developed the ultimate tool for getting the job done right. Minimum downtime, maximum […]

Read more

high speed data migration: maintaining performance

One of the biggest obstacles faced by people who want to migrate quickly is performance. But your performance doesn’t have to suffer. CYBERTEC Migrator is likely the fastest solution out there to reliably ship data from Oracle to PostgreSQL. We use state-of-the-art techniques such as parallelization and change data capture to ensure we stay at […]

Read more