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.
PostgreSQL 15 introduced a crucial change regarding permission checks in logical replication, to avoid a potential security violation. Let me show you how this improvement works.
With growing adoption among developers and the support of major hyperscalers, the time has come for organizations to make a choice and experience the benefits of PostgreSQL. How did it happen?
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...
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.
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.
Last month, I was proud to talk about the internals of logical replication to a room full of PostgreSQL enthusiasts at PGConf India 2023. In case you missed it, let's go through it together.
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.
With the vast amount of data being handled by organizations, they face enormous pressure to effectively harness this information so it can be used to make timely and informed decisions in order to stay ahead of the competition.
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.
PostgreSQL 15 doesn’t disappoint. Upon arrival of the new release, the long-awaited MERGE feature will be delivered. It may not have been with the speed of light, but right on time like a door dash delivery.
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.
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.
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.
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.