Data Egret

01/05/2026

A week on from PGConf.DE 2026 in Essen, we now have our slides and thoughts together! 🐘

This year, four of our colleagues took to the stage covering topics across high availability and backup strategies, safe schema migrations, the business case for open-source contribution, and real-time analytics pipelines.

📖 Read our full recap including slides from all four talks here:
https://dataegret.com/2026/05/recap-pgconf-de-2026/

Inspired, energised—and with a slight post-event dip—our team just got back from PGConf.DE 2026 in Essen! The 10th Annual PostgreSQL Conference Germany took place on April 21–22,...

29/04/2026

If you’re in Munich next week, come join us at the PostgreSQL Meetup! 🍻

Our CEO, Ilya Kosmodemiansky, will be speaking about “Operating Postgres as a data source for your analytics pipelines” — a topic that’s becoming increasingly important as more teams rely on real-time analytics.

You’ll hear practical insights on:

* change data capture (CDC)
* running Postgres under analytical load
* tools like Debezium, Kafka, Flink, and more

Plus, there are two more great talks:
🔹 The Role of PostgreSQL in the AI World — Sikandra Chaudhary (AWS)
🔹 Sneak Preview: New Features in PostgreSQL 19 — Michael Banck (Credativ)

📅 Tuesday, 5 May | 5:30 PM – 8:30 PM
📍 Munich

👉 Join here: https://www.meetup.com/postgresql-meetup-munich/events/314378267/?eventOrigin=group_upcoming_events

Can’t make it but interested in the topic? Check out our white paper on PostgreSQL and analytics pipelines:
https://dataegret.com/white-paper/

We are excited to announce our first 2026 PostgreSQL Meetup! AWS (Amazon Web Services) has graciously offered to host us again on May 5th, starting 18:00. Complete speaker

21/04/2026

🎤 Happening now in Saal B!
Daria Nikolaenko is presenting:
“PostgreSQL Migrations Without Drama”

Schema and data changes are part of everyday development, but in PostgreSQL, they can quickly impact performance and availability if not handled carefully.

In this session, Daria walks through:

- how schema changes affect live workloads,
- why certain operations cause blocking,
- how to reduce risk when applying DDL and DML in production,
- and what to watch out for with large data modifications.

If you’re at PGConf.DE, don’t miss out!

14/04/2026

One of the things we believe in at DataEgret: the knowledge our DBAs carry shouldn't stay internal.

Thom Brown — one of our senior PostgreSQL engineers — has published a deep dive into using psql. These tricks actually change how you work: `\gexec`, `\gset`, `\watch`, `\crosstabview`, `\errverbose`, and a `.psqlrc` that turns the CLI into a personal toolkit.

👉 Full post: https://dataegret.com/2026/04/psql-tricks/

Thom also authored our free PostgreSQL Maintenance Health Check Guide, which covers the operational side of keeping Postgres healthy in production:
🔗 https://dataegret.com/white-paper-postgresql-maintenance/

Boost your PostgreSQL workflow with practical psql tips: expanded output, saved queries, live dashboards, and powerful command-line tricks.

09/04/2026

The demand for PostgreSQL expertise has never been higher - and certified, experienced PostgreSQL DBAs are still genuinely hard to find.
If you are looking to upskill, change roles, or simply stay ahead of the curve in 2026, we have new dates across all three of our PostgreSQL training courses:

🎓 DBA1 - PostgreSQL Essentials
🎓 DBA2 - PostgreSQL Advanced
🎓 DBA3 - PostgreSQL Backups and Replication

Why train with Data Egret?
✅ Taught by senior DBAs who work with production PostgreSQL every day
✅ Live, interactive sessions with real demos and Q&A
✅ Certificate from a recognised PostgreSQL consultancy
✅ Small cohorts - real attention, real conversations

5 live online sessions per course · 3h30m each · €850 before taxes

👉 Register here: https://dataegret.com/postgresql-courses/

01/04/2026

🚨 ELITE DBA FOR HIRE — NOW INCLUDING REALITY SUPPORT🚨

After decades of PostgreSQL mastery, we are finally offering our most advanced DBA as a service.

📩 Book now before we run out!

19/03/2026

PostgreSQL major version upgrades are routine. They are also full of small details that can turn a quiet maintenance window into an incident.

Ilya Kosmodemiansky, our CEO, has just published a comprehensive guide to upgrading PostgreSQL in 2026 — based on his PGConf EU 2024 talk, updated for the 17→18 upgrade path.

What's covered:

→ pg_dump, pg_upgrade, and logical replication — when to use which
→ The biggest pg_upgrade improvement in PG 18: optimiser statistics are now preserved by default
→ The new --swap mode and parallel-- jobs checks
→ Rollback strategies that hold up in production (link mode, pgBackRest, replica failover)
→ PgBouncer coordination during switchover
→ A full step-by-step walkthrough tested on Ubuntu 22.04

If you are still running PostgreSQL 16 or earlier, now is an excellent time to plan your upgrade.

Read the full guide 👇

An Ultimate Guide to Upgrading Your PostgreSQL Installation: From 17 to 18 PostgreSQL Major upgrades: ultimate guide in 2026

11/03/2026

🔄 Database migrations are complex.

Moving from Oracle or MS SQL Server to PostgreSQL is not a “dump & restore” exercise.

It involves:
• Architectural redesign decisions
• Schema and query adaptations
• Performance testing under real load
• Monitoring adjustments
• Switchover planning
• Post-migration stabilisation

Without a structured roadmap, costs and timelines can quickly spiral.

That’s why every successful migration starts with:

✔ A migration workshop
✔ A clear architectural roadmap
✔ Identified risks and phased ex*****on

If you’re evaluating PostgreSQL but want to avoid migration surprises, our migration guide outlines the full process:

👉 Download now: https://dataegret.com/migration-to-postgresql/

Streamline your database migration with expert PostgreSQL support from Data Egret — zero downtime, zero guesswork.

03/03/2026

🚀 We’re pleased to announce a strategic partnership between Data Egret and SolarWinds.

As PostgreSQL environments grow in scale and complexity, visibility alone is no longer enough. Organisations need the expertise to translate performance insights into architectural improvements and long-term resilience.

SolarWinds Database Performance Analyzer (DPA) provides valuable visibility into PostgreSQL environments. Data Egret transforms those insights into concrete architectural improvements, performance optimisation strategies, and long-term scalability frameworks.

Together, we enable organisations not only to detect issues — but to resolve root causes and strengthen their PostgreSQL foundations.

More details about the partnership:
https://dataegret.com/2026/03/data-egret-and-solarwinds-announce-partnership/

If you’re interested in exploring collaboration opportunities around PostgreSQL excellence, we welcome the conversation.

We’re excited to share that Data Egret is now partnering with SolarWinds to help engineering and operations teams turn PostgreSQL performance insights into real, measurable improvements. SolarWinds...

19/02/2026

There is still time to sharpen your PostgreSQL DBA fundamentals!

Our DBA1 – PostgreSQL Essentials course (23–27 February) starts on Monday!

It’s an intensive, five-day course for DBAs who want a solid, practical foundation in PostgreSQL operations.

We’ll cover:
• PostgreSQL installation
• Core PostgreSQL concepts
• Day-to-day DBA tasks
• Maintenance and operational best practices

If you’re new to PostgreSQL or want to solidify your fundamentals, this course is a great place to start.

👉 Details & registration:
https://dataegret.com/courses-postgresql-essentials-dba1/

Intensive five-day course for database administrators who want to build a strong foundation in PostgreSQL operations and management.