Knowledge & Insights

Blogs & Insights

Latest articles from HexaCluster on PostgreSQL, database migration, performance tuning, and database modernization.

Recent Articles

Partitioning by Reference - Oracle vs PostgreSQL

Sometimes, when you are working on a migration to PostgreSQL, you can encounter features that do not exist in PostgreSQL. This especially happens when we do not have any extension to emulate the feature you are looking at.

Sometimes, when you are working on a migration to PostgreSQL, you can encounter features that do not exist in ...

Gilles Darold

•Feb 29, 2024

AUTOCOMMIT - Oracle vs PostgreSQL

postgresqlOracle

Oracle and PostgreSQL differ significantly in their transaction models, and AUTOCOMMIT is one of those differences. We see many of our customers successfully migrate code, but still encounter variations in behavior and even runtime errors related to

Oracle and PostgreSQL differ significantly in their transaction models, and AUTOCOMMIT is one of those differe...

Akhil Reddy Banappagari

•Feb 27, 2024

Data Navigation with PostgreSQL Cursors – Part II

postgresqlCursors

Welcome back to the second article in our series exploring PostgreSQL cursors. In the first part of this series, we explored the fundamentals of scrollable cursors.

Welcome back to the second article in our series exploring PostgreSQL cursors. In the first part of this serie...

Jagadeesh Panuganti

•Feb 01, 2024

2023: Year of Generative AI

Gen AIAI

2023’s journey in AI technology, particularly Generative AI, has been marked by significant refinements and enhancements to existing platforms, like ChatGPT or groundbreaking image generators. Notably, these advancements have been the major reason fo

2023’s journey in AI technology, particularly Generative AI, has been marked by significant refinements and en...

Suman Michael

•Jan 12, 2024

Data Navigation with PostgreSQL Cursors - Part I

postgresqlCursors

Navigating large datasets quickly and effectively is critical when it comes to database management systems. One of PostgreSQL's core features, cursors are vital tools for accurately navigating and modifying query results. During the migration from Or

Navigating large datasets quickly and effectively is critical when it comes to database management systems. On...

Jagadeesh Panuganti

•Jan 10, 2024

PostgreSQL Contributions by the Team at HexaCluster in 2023

postgresql

The team at HexaCluster can proudly be referred to as PostgreSQL contributors. Our team is one of the strongest reasons for increasing migrations to PostgreSQL and also the adoption of PostgreSQL.

The team at HexaCluster can proudly be referred to as PostgreSQL contributors. Our team is one of the stronges...

Akhil Reddy Banappagari

•Jan 09, 2024

Start your migration journey 🚀

start your migration journey with our expert team

Blogs & Insights

Recent Articles

Partitioning by Reference - Oracle vs PostgreSQL

AUTOCOMMIT - Oracle vs PostgreSQL

Data Navigation with PostgreSQL Cursors – Part II

2023: Year of Generative AI

Data Navigation with PostgreSQL Cursors - Part I

PostgreSQL Contributions by the Team at HexaCluster in 2023

Products

HexaRocket 🚀

Migration Services

PostgreSQL Consulting