In this blog post, I will give a brief introduction to a new PostgreSQL 16 feature that allows bi-directional replication by filtering by origin.
As a PostgreSQL DBA, we commonly hear and use the term "dead rows" and "bloat." In this blog post, I'd like to talk about these concepts as well as "transaction wraparound," one of the most dangerous situations in PostgreSQL. I'll also outline how to handle this problem with an example.
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.
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.
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.
