PostgreSQL 15 logical replication enhancements - in action (with demo videos)
The latest PostgreSQL 15 release brings significant improvements to logical replication, which fortifies CREATE/ ALTER PUBLICATION capabilities, and benefits by enhancing security, improving ease of use, and reducing network traffic.
How PostgreSQL improved statistics collector in the latest version
The latest version of the popular open-source database management system, PostgreSQL 15, has made significant changes to its statistics collector. The new changes aim to improve its accuracy and efficiency, making it easier for database administrators to monitor and optimize their PostgreSQL databases.
Understanding the new pg_basebackup options
In this post, I would like to highlight the OSS enhancements to pg_basebackup inherited by Fujitsu Enterprise Postgres 15 that enrich the native backup utility and how the new --target and --compress options can be leveraged for database administration and operations.
The PostgreSQL Community in India gathered for PGConf- here's what happened
Fujitsu Enterprise Postgres was a proud sponsor of PG Conf India this past month, where over 400 attendees, representing 60 cities, across 10 countries travelled to Bangalore in India. Over three days, guests engaged in training workshops, Lightning Talks, and presentations encapsulating the latest contributions, knowledge sharing, updates, and hot topics in the wider open-source PostgreSQL...
What's new in Fujitsu Enterprise Postgres 15? A closer look at some of the features
Earlier this week, we announced the launch of Fujitsu Enterprise Postgres 15, with enhanced capabilities to manage enterprise data across multiple environments with security, agility, and flexibility. In this post, I will highlight some of the new features available in this release, with examples comparing it with the previous release.
Announcing Fujitsu Enterprise Postgres 15 - the hybrid multi-cloud Postgres you can rely on
Fujitsu continues to keep in step with the needs of enterprise-level environments with the proud launch of Fujitsu Enterprise Postgres 15. The highly anticipated release boasts additional features developed with the end user in mind, ensuring clients are provided with a hybrid multi-cloud solution that meets their business critical requirements head on.
Using postgres_fdw.parameter_name for advanced monitoring with multiple PostgreSQL servers
A new feature introduced in PostgreSQL 15 allows tuning the name of the application used by postgres_fdw. In this post, I will talk about the background of this feature and how you can use it to better identify which application executed each SQL statement on a foreign server.
PostgreSQL 15 and beyond
PostgreSQL 15 builds upon the enhancements of earlier versions and takes them to the next level, with several improvements to logical replication, increased sorting performance, and the introduction of the MERGE command. I would like to talk about these features as well as what is under discussion for PostgreSQL 16.
Making Postgres management easier with DBeaver
PostgreSQL keeps evolving and adding features that make it easier to manage your data so you can unlock its full potential. But if you and your team need to work with multiple databases, you should consider using a powerful and robust database management tool such as DBeaver.
The race for carbon neutrality
Efficient software technologies reduce the energy usage of computing systems, which in turn help lower carbon emissions in data centers. By adopting efficient technologies designed to minimize the use of computational resources, we can decrease the carbon footprint of the IT industry and contribute to the goal of carbon neutrality.
Performance impact of row filters and column lists in logical replication
New features introduced in PostgreSQL 15 allow selective publication of tables' contents within logical replication publications, through the ability to specify column lists and row filter conditions. Let's see how they affect performance.
Fujitsu attends the Open Source Summit Europe 2022 in Dublin
After a long season of no in-person events due the pandemic, I can say with certainty that attending the Open Source Summit event in Dublin along with my fellow Fujitsu representatives was not only thoroughly enjoyable, but also a great opportunity to catch up with the community. Here are my thoughts.
Column lists in logical replication publications - an overview of this useful PostgreSQL feature
PostgreSQL 15 introduces a new feature that allows specifying column lists in publications, to restrict the amount of data replicated. Let's see what are the advantages of this feature and how to use it.
Beyond green computing with Fujitsu Enterprise Postgres on IBM LinuxONE Emperor 4
Together, Fujitsu and IBM are helping clients build a modern environment that is designed to improve business agility and reduce overall costs by leveraging the next generation of IBM LinuxONE’s highly secured and sustainable platform. Read more here.
How data portability benefits not only your customers but also your organization
The concept of data portability is relevant not only as part of the regulatory framework governing customer data privacy - it is also important for organizations moving data across applications and hybrid cloud. Let me show you how.
Two-phase commits for logical replication publications/subscriptions
The upcoming PostgreSQL 15 introduces a new feature added by the Fujitsu OSS team in collaboration with the PostgreSQL open source community that allows supporting of two-phase commits in logical replication using publications/subscriptions. Let's take a look at how to use it.
Data security and compliance challenges in today’s landscape
The global average cost of data breach in 2021 was over $4.2M†, surging 10% from last year. As data becomes ever more valuable, organizations must fend off cyber-attacks which keep increasing in number and sophistication.
Fujitsu Enterprise Postgres with SUSE Linux Enterprise on IBM LinuxONE - delivering power, resilience, security and automation
Agility is a key element for success. This is why I am excited to introduce the newest option for your next agile data platform, featuring Fujitsu Enterprise Postgres with SUSE Linux Enterprise on IBM Z / LinuxONE systems.
Enhancements to the target_session_attrs database connection parameter in PostgreSQL 14
In this post, I will discuss the enhancements that will be added to the database connection setting target_session_attrs in PostgreSQL 14, explain the history behind this feature, how it can be used, and the various benefits it provides.
Securing your data with Transparent Data Encryption
Information Technology security is getting more complex each time I visit the subject. This just makes it harder for Security Specialists, whose role is to ensure that all potential threats are mitigated across the myriad of hardware, firmware, and software that make up a modern Enterprise Infrastructure.
How to configure PostgreSQL and Fujitsu Enterprise Postgres as a systemd service
Servers these days are pretty reliable and can go long periods of time between restarts — but when a restart of several machines does occur, we don't want to find out that services haven't started up by hearing it from our customers.