< Back to blog home Fujitsu PostgreSQL blog

Fujitsu PostgreSQL Blog listing page

|

Seamlessly upgrade PostgreSQL subscribers with PostgreSQL 17's new feature that preserves logical replication states, ensuring continuous and reliable data synchronization.

PostgreSQL Down Under 2025 in Sydney showcased innovation, collaboration, and technical depth, featuring expert talks and community engagement after a six-year hiatus.

Discover how the pg_repack extension optimizes PostgreSQL databases by reorganizing tables and rebuilding indexes with minimal downtime.

PostgreSQL 18 shows a forward-looking shift—embracing modern SQL standards and sharpening the developer experience. It’s about smarter queries and smarter systems that guide us along the way

Enhance your RAG pipeline in PostgreSQL by incorporating facets and disciplined prompt design for more precise and relevant document retrieval.

Discover the latest enhancements in pg_createsubscriber for PostgreSQL, streamlining logical replication and improving usability and flexibility.

See how to optimize RAG in PostgreSQL for smarter retrieval and context, ensuring more relevant and structured responses from your AI models.

PostgreSQL 18 revolutionizes database performance with AI-ready features and cloud-native capabilities, setting the stage for future innovations in PostgreSQL 19 and beyond.

Learn how to enhance your PostgreSQL searches with Retrieval-Augmented Generation (RAG) for precise, context-aware answers using vector embeddings and language models.

Exploring the Vertical Clustered Index (VCI) for PostgreSQL, enhancing real-time data analysis while maintaining update performance, as presented at PGConf.dev.

Learn how pg_createsubscriber simplifies converting physical standbys into logical replicas in PostgreSQL 17, speeding up setup and reducing resource overhead.

At PGConf.dev, PostgreSQL experts Ajin Cherian and Zhijie Hou discussed how PostgreSQL 18 will enhance logical replication with automated conflict resolution.

Learn how to efficiently embed content into PostgreSQL using Python, focusing on markup chunking and token-aware chunking for optimal semantic search and retrieval.

Efficiently store, query, and manage vector embeddings in PostgreSQL for powerful similarity searches without sacrificing performance or maintainability.

Discover why sentence-level embeddings are crucial in modern vector search systems and how they enhance semantic search, recommendation engines, and retrieval-augmented generation (RAG).

Learn the key differences between similarity and distance in PostgreSQL vector search and how to apply them effectively in your queries.

Shlok Kyal was at PGConf India 2025, discussing how to upgrade PostgreSQL replication clusters without downtime using new logical replication features.

Discover why a strong database foundation is essential for enterprise AI success, emphasizing structured, clean data over chaotic data swamps for trustworthy, reliable AI outcomes.

An in-depth investigation into a cryptomining incident demonstrates how seemingly minor security gaps in PostgreSQL environments can be leveraged by attackers.

Gary Evans and Nishchay Kothari were at PGConf.dev in Montreal talking about learned indexes in PostgreSQL. Here, they share what they discussed.

Discover how PostgreSQL 17 enhances high availability in logical replication with failover logical slots, reducing downtime and ensuring seamless data continuity.

Enhance fraud detection with Fujitsu Enterprise Postgres 17 SP1, leveraging Agentic AI for adaptive, intelligent defense against emerging AI-driven financial threats.

Explore the essentials of Write-Ahead Logging (WAL) in PostgreSQL, covering its components, crash recovery, and replication mechanisms.

Enhance security of Fujitsu Enterprise Postgres for Kubernetes with HashiCorp Vault. Learn how to manage sensitive data effectively and securely in a cloud-native environment.

Experience the AI-driven advancements of Fujitsu Enterprise Postgres 17 SP1, enhancing database security, performance, and RAG compatibility for optimized AI applications.

Discover how Fujitsu's PostgreSQL team made impactful contributions in 2024, driving innovation and supporting the PostgreSQL community's growth.

Fujitsu showcased its PostgreSQL expertise at PGConf India 2025, highlighting innovation and community collaboration in the open-source database space.

The public sector's adoption of open-source technology, exemplified by PostgreSQL, drives innovation, collaboration, and efficiency while addressing data management and security challenges. Tim Steward and Brentley Thomason share their insights.

Discover why quantum-safe PostgreSQL is essential in today's rapidly advancing technological landscape and learn how to secure your data against future quantum threats.

Marcos Figueiredo announces Fujitsu Enterprise Postgres 17 with secure RAG application support and cloud operability that make it the Postgres solution of choice.

Amit Kapila lists the new features introduced in PostgreSQL 17, and shares his views on what is in store for PostgreSQL 18 and beyond.

Hayato Kuroda explains new logical replication features in PostgreSQL 17 and his experience in PGConf.dev in Vancouver, Canada.

Koshi Shibagaki highlights 3 key security risks in leveraging in-house data for generative AI applications, and how Fujitsu's enterprise features secure your PostgreSQL database.

Gary Evans shares his participation in FOSSASIA Summit 2024, held in Hanoi, and his view on the enthusiasm in open source technology adoption in Asia and beyond.

Niki Kennedy discusses the partnership between Fujitsu and TD SYNNEX to expand the availability of Fujitsu Enterprise Postgres, the enterprise-enhanced PostgreSQL

Gary Evans discusses how Fujitsu Enterprise Postgres ensures robust data security with ScalarDL, providing guaranteed non-tamperability for personal information protection.

Hayato Kuroda gives you a brief look on his day as a Postgres developer in Fujitsu, and shares what he is looking forward to this year.

Zhijie Hou shares his daily experience as a Postgres developer in Fujitsu, and talks about his passion and dedication to PostgreSQL.

What is Postgresql?

Vigneshwaran C shares what a day is like for him as a PostgreSQL engineer in Fujitsu OSS team.

Peter Smith, Fujitsu OSS team, from Sydney, Australia, shares what a day it is like for him to be a part of the PostgreSQL community.

Diverse, committed, and global – true for the community, true for Fujitsu engineers. Let me introduce you to a series of blogs by some of our talents in the Fujitsu OSS team.

Stay ahead of cyber threats in 2024 with our series on Database Security. Enhance your cybersecurity awareness and protect your data with insights from our Postgres expert Gary Evans.

Explore the crucial role of detection in cybersecurity for Database Administrators in the NIST Cybersecurity Framework.

Learn about the crucial role of governance and data security for Database Administrators in the NIST Cybersecurity Framework. Discover how DBAs contribute to ensure data security for organizations.

Learn how Database Administrators (DBAs) can navigate the complex landscape of cybersecurity and manage risks to their databases. Explore the importance of asset management and risk assessment in aligning with the NIST Cybersecurity Framework's 'Identify' pillar. Discover key steps for DBAs to establish a robust foundation for risk assessment and the integration of risk assessment with broader...

We are pleased to announce that Fujitsu Enterprise Postgres is FIPS-certified to give you the peace of mind that your data is safer than ever.

Aya Hoshino describes the challenges in DR in a Kubernetes environment and how our latest release provide reliable, robust recovery for enterprise systems.

Learn about the different types of encryption and their strengths for database administrators. Find out how understanding encryption can help fortify your database and make informed security choices. Stay encrypted, stay secure!

Read about the importance of encryption in database security and how it protects data at rest and in transit. Learn about encryption types, key management, and the role of application-level encryption. Find out how Fujitsu Enterprise Postgres provides robust encryption solutions for enhanced data security.

Fujitsu Enterprise Postgres fourth win as DB-Engines' Database of the Year showcases its excellence and adaptability in the modern data landscape.

Deepen your understanding of database security and learn how to secure your PostgreSQL kingdom with effective authorization and cybersecurity framework alignment. Read about the various authorization methods and their importance in the broader cybersecurity landscape.

Discover the importance of revoking excessive Data Manipulation Language (DML) privileges in PostgreSQL. Learn how to strengthen your database's defense mechanisms with the CIS Benchmark for PostgreSQL 16.

Gary Evans discusses the key role of security benchmarks in protecting databases, and how to adapt them to suit your organization's unique needs. Enhance your database security strategy with these guidelines.

Gary Evans writes about the key roles that play a crucial role in your organization's data defenses to stay ahead of potential data breaches.

Discover how Fujitsu Enterprise Postgres and Google Cloud services are revolutionizing data management and utilization infrastructure, providing enhanced security and flexibility for businesses.

Gary Evans starts a new series of articles around the importance of database security in the ever-changing cybersecurity landscape. Explore the role of cybersecurity frameworks and learn how to protect your data from unauthorized access and threats. Stay informed and stay secure!

Innovatus Media’s Managing Director Matthew Egan discusses how the adoption of open source can drive innovation and efficiency in the financial sector.

Tim Steward uses one of his favorite books as a starting point to discuss the power of PostgreSQL as a purpose driven database.

Our guest contributor, Innovatus Medias’ Managing Director Matthew Egan from our recent event in London: "The future of open source: Enabling Secure and Scalable Open Source in Finance."

In this blog, Nishchay Kothari explains how to use policy based password management to secure your database and enhance access control.

Aya Hoshino describes new enterprise features released in Fujitsu Enterprise Postgres 15 SP1 for enhanced security and HA for your mission-critical system.

Tim Steward discusses how the role of the DBA is constantly evolving and adapting to respond to the ever-changing technology landscape.

Our database expert Tim Steward discusses how you can unlock the power of geospatial data to gain valuable insights into natural and human phenomena.

Amit Kapila lists the new features introduced in PostgreSQL 16, and shares his views on what is in store for PostgreSQL 17 and beyond.

In this blog, Vigneshwaran from the Fujitsu PostgreSQL team explains the new bi-directional replication feature in PostgreSQL 16 and how to configure it.

In this blog, Nishchay Kothari explains what is "transaction wraparound" and what to do if your PostgreSQL system is affected by it.

Nishchay Kothari explains how to connect pAM authentication in Fujitsu Enterprise Postgres.

Nishchay Kothari explains how to connect Fujitsu Enterprise Postgres with Active Directory using LDAP, one of the most common ways organizations secure authentication.

Rajesh Kandasamy describes three enhancements to logical replication in PostgreSQL15 along with demo videos showing you how to use these features.

Ajin Cherian explains a crucial change regarding permissions in logical replication introduced in PostgreSQL 5 to avoid a potential security violation.

Nishchay Kothari explains the improvements to the stats collector in PostgreSQL 15, which allows improved statistic collection, analysis, and reporting.

Tim Steward explains how PostgreSQL has emerged as the clear alternative to proprietary databases, backed by a diverse community of developers.

Rajesh Kandasamy explains the new options in the pg_basebackup utility that allow users to specify target backup and compression locations.

Kathryn Bourrne talked to Amit Kapila and Vigneshwaran C about their impressions of PGConf India 2023.

Nishchay Kothari describes some of the new features available in the latest version of Fujitsu Enterprise Postgres and explains their benefits.

Marcos Figueiredo announces Fujitsu Enterprise Postgres 15 with additional security features that make it the hybrid multi-cloud Postgres you can rely on.

Hayato Kuroda discusses the new connection setting in Postgres 15 that increases visibility of query status and helps manage PostgreSQL systems better

Vigneshwaran C explained the internals of PostgreSQL Logical Replication during PGConf India - if you were not able to attend, you can read all here.

Amit Kapila lists the new features introduced in PostgreSQL 15, and shares his view on what is in store for PostgreSQL 16 and beyond.

Timothy Steward talks about the benefits of using a powerful database management tool, more specifically DBeaver.

Timothy Steward discusses the challenges faced by organizations to harness the vast amount of data generated so they can make timely and informed decisions.

Vincent O'Dea brings programming language efficiency into the discussion of sustainability, and explains what part Kubernetes, Operator, and Rust can play.

Timothy Steward writes about the new MERGE command introduced in PostgreSQL, and how you can you use it to simplify your code.

Yu Shi puts PostgreSQL's row filter and column list features to the test, to check how much they can affect logical replication performance.

Vincent O'Dea shares his journal and photos from the 2022 Open Source Summit, held in Dublin Ireland.

C Vigneshwaran writes about the PostgreSQL feature that allows you to specify a column list in logical replication publications.

Niki Kennedy announces the availability of Fujitsu Enterprise Postgres on IBM LinuxONE Emperor 4, to deliver a sustainable, resilient, and scalable platform

Wei Wang explains improvements to the communication of logical replication in PostgreSQL 15.

Vincent O'Dea discusses how the planet has been steadily warming, and how technology can be a part of the solution to this problem by decarbonizing compute

Fujitsu and PostgreSQL community worked on publication rows filter for logical replication, so only row data that matches specified filters is replicated.

In the conclusion of his posts on PostgreSQL mechanisms to address logical replication conflicts, Takamichi Osumi talks about ALTER SUBSCRIPTION SKIP.

Takamichi Osumi explains how new mechanisms in PostgreSQL make it easier to address replication conflicts.

Gary Evans writes about the concepts of Data Portability, its benefits, and how it can easily be applied in Fujitsu Enterprise Postgres databases.

Niki Kennedy announces the availability of Fujitsu Enteprise Postgres in the IBM Power® platform.

Ajin Cherian writes about the new feature added in PostgreSQL 15 that allows supporting of two-phase commits in logical replication using publications/subscriptions.

Matthew Kemp discusses what are the challenges to overcome in ensuring data security and regulatory compliance in today's business landscape.

C Vigneshwaran writes about the new feature in PostgreSQL that allows users to specify tables in schemas to be used in logical replication.

Takamichi Osumi explains how to pg_stat_replication_slots to gain a better understanding of how logical replication is carried out by PostgreSQL.

Amit Kapila shares his views on the future of PostgreSQL and discusses what we can expect in future versions.

Haiying Tang takes you on a tour of LZ$ TOAST, the new column opton compression in PostgreSQL 14, and shows the speed and compression ratio gains.

Peter Smith explains Logical Replication Tablesync Workers

In this blog, Manish Srivastava makes the case why Financial Services should adopt a hybrid cloud strategy.

Terry Smith discusses how Fujitsu Enterprise Postgres with SUSE Linux Enterprise on IBM LinuxONE delivers power, resilience, security, and automation to your data.

Ajin Cherian gives a deep-dive of a new feature in PostgreSQL 14: logical decoding of two-phase commits.

Aya Iwata walks us through the libpq logging improvements that enhance usability of PostgreSQL 14.

Fujitsu Enterprise Postgres for Kubernetes is now available on Red Hat Marketplace

In this blog, Manish Srivastava discusses the challenges that the financial services industry faces when adopting DevOps.

Greg Nancarrow discusses enhancements added to the target_session_attrs parameter in PostgreSQL 14, the history behind it, and how to make the best of it.

Hayato Kuroda explains why support for DECLARE STATEMENT was committed to PostgreSQL 14 code base, and how it makes migration easier and source code shorter.

Kirk Jamison shares about his patches committed to Postgres14, which speeds up recovery by optimizing the dropping of relation buffers.

Takamichi Osumi shares about his patch CREATE OR REPLACE TRIGGER committed to Postgres14.

Pankaj Kapoor discusses table access methods for PostgreSQL and their importance for developers, expanding on his talk on PGCon 2019.

Amit Kapila shares his views on the future of PostgreSQL and discusses what we can expect in future versions.

Amit Kapila shares his views on PostgreSQL 13 and what's in store for PostgreSQL 14.

Meet Amit Kapila, PostgreSQL Committer and Major Contributor, now leading Fujitsu's PostgreSQL team as Senior Director.

In this post, we explain what are IBM CrytpoCards, and provide a step-by-step on how to use them with Fujitsu Enterprise Postgres.

Fujitsu Enterprise Postgres on IBM LinuxONE is now available to allow organizations to provide a secure and scalable platform for enterprises

Our new section is aimed at PostgreSQL enthusiasts, from newcomers to seasoned experts, to share and disseminate knowledge of Postgres fundamentals, how-to's, tips and tricks.

See how Fujitsu Enterprise Postgres on IBM LinuxONE allows organizations to provide a secure and scalable platform for enterprises

This blog explains how Fujitsu Enterprise Postgres enhances PostgreSQL data security with Transparent Data Encryption and Data Masking

PGDU is a one-day conference managed by PostgreSQL Down Under Incorporated, a not-for-profit organisation created to support the growth and education of PostgreSQL within Australia and New Zealand.

Legacy system data is often too large, complex, or critical to risk a rewrite into a new language. Fujitsu Enterprise Postgres though gives you the best of both worlds where you can reuse your C and COBOL data and systems without the risk and expense normally associated with porting old code.

In this post, I discuss how PostgreSQL maps the database objects into physical files, and how this affects security in non-encrypted environments.

The constant onslaught of new digital technology has drastically altered our ability to collect, store, and analyse information. The new data that this delivers is revolutionising the way that governments, countries, and society at large will function.

In this post, I explain how Transparent Data Encryption can be quickly deployed to secure your data even if hackers gain access to your system.

The Postgres community gathered in Ottawa on May to discuss current trends and future developments, and I had the opportunity to talk about pluggable table access methods - here is my account of the event.

Servers these days are pretty reliable , but configuring PostgreSQL and Fujitsu Enterprise Postgres as a systemd service adds an extra layer of reliability

The way organizations use data is now impacting their brand reputation. Progressive brands are taking advantage by building their data strategies, investments, and protection policies into their brand identity - and winning.

When importing large amounts of data, it is especially important to choose the right approach, because any per-record overhead will be multiplied by thousands or millions. Read how.

Yes, you can have an open source database strategy and deliver compliance with dedicated audit logging. Fujitsu Enterprise Postgres delivers with a Dedicated Audit Log feature for data accountability, traceability, and auditability.

Organisations need to constantly worry about securing their data. In this post we explore how to provide maximum security to stored passwords in your system using PostgreSQL pgcrypto hashing and cryptography module.

On top of attending to the safety measures required to protect your data, you also need to worry about how much it will cost and how it will affect existing business applications. Or you can use Transparent Data Encryption baked into Fujitsu Enterprise Postgres.

Open Banking is a 2-day conference in Sydney gathering key players and experts from the banking, finance, and ICT sectors to discuss strategies, challenges and opportunities as they prepare for the new era of open banking in Australia in 2020.

Open Banking is revolutionising the banking experience all over the world, bringing challenges and opportunities for traditional banks and financial institutions as well as for fintechs. Learn more about it here.

The micro-services architecture is increasingly popular for software development because of its ability to simplify scaling, improve app development results, and increase system reliability. See why it is important to choose the right data persistence and how FUJITSU Enterprise Postgres can help.

Open source software is a time-proven solution for creating greater freedom for innovation. Here's why.

What is Mirroring Controller in Fujitsu Enterprise Postgres and how does it help retain business continuity and data integrity in the case of disruption or abnormality.

The DevOps approach is proving popular for organisations looking to speed up their app and software delivery significantly. Here's how open source database technology such as PostgreSQL (and Fujitsu Enterprise Postgres) can help.

PGDU is a one-day conference managed by PostgreSQL Down Under Incorporated, a not-for-profit organisation created to support the growth and education of PostgreSQL within Australia and New Zealand.

PostgreSQL could change the database market just as Linux did operating systems. Read how.

Fujitsu has delivered the capability with PostgreSQL to extend and support enterprise applications demanding Hybrid Transactional/Analytical Processing (HTAP) capabilities.

PGCon 'unconferences' are now a critical part of the PostgreSQL development process. Here's why.

Fujitsu Enterprise Postgres has been designed with Vertical Clustered Index (VCI), Fujitsu's proprietary implementation of In-Memory Column Store, to improve speed by up to 46x when analysing data and running business transactions at the same time.

Fujitsu Enterprise Postgres has been designed to help you deliver new data-based services and solutions while also gaining significant operational efficiencies via a seamless migration and long-term reduced cost of ownership. This makes the decision to consider an alternate data vendor a good one.

Trust is the basis of business relationships. And transparency is the basis of trust. So what should you do if a data breach occurs in your organisation? We can look to the new Notifiable Data Breaches (NDB) scheme in Australia for some guidance on the topic.

Here are 10 tips to help you manage your technology and processes now new data breach legislation known as The Privacy Amendment (Notifiable Data Breaches) Act 2017 is now in operation in Australia.

There are countless ways by which your information can become vulnerable to data breaches. We tackle three of them here and what you can do to mitigate the risk.

You can review my presentation that covers how you can tune PostgreSQL to reduce the chance of being breached and all the costs and penalties associated with such an event.

As the volume of data of a personal nature and commodification of information collected and analysed increases; so is the focus on privacy and data security.

In 2016, the Australian government passed a bill called the Privacy Amendment (Notifiable Data Breaches) Bill 2016, which is designed to establish a mandatory data breach notification scheme in Australia.

Fujitsu Australia Software Technology is a Platinum Partner of this year's PGConf APAC 2018 event. Register early as places are limited.

New data breach laws in Australia have made Data Masking even more critical for organisations that retain sensitive personal data.

This is a simplified explanation for DBAs as to the significant memory areas of a PostgreSQL instance and how are they allocated?

The Meltdown and Spectre bugs are hardware vulnerabilities and are not specifically a problem for FUJITSU Enterprise Postgres or PostgreSQL.

You'll be required to manage a data migration project from a legacy system to a new platform at some time in your career. Here are six tips to help.

With Fujitsu’s PostgreSQL Support, our highly trained PostgreSQL experts in Australia will have you covered, so you can focus on the growth of your business.

PostgreSQL proves its rapidly growing popularity by winning Database Management Systems of the Year for 2017 as ranked by DB-Engines.

Digital transformations demand the type of database migrations that have become increasingly more complex. Read how to minimise their risk.

The growth of your business through digital transformation is supported by Fujitsu as our state-of-the-art technologies offer high reliability and performance.

PGDay Australia successfully re-ignites the PostgreSQL community across our region and sees the launch of PostgreSQL Down Under Inc.

Here's why open source is recognised as perhaps the best way to develop software.

See how Fujitsu converges open source software with commercial software to create the best of both worlds.

Fujitsu Australia Software Technology is hosting the 13th Annual Charity Golf Day at the Australian Open to support Camp Quality.

Here's how to fix the situation where the pg_wal directory fills up and no new files can be created in PostgreSQL.

This is the 1st in a series of blogs looking at how to centralise authentication and authorisation in PostgreSQL similar to that of best practice in SQL Server.

I am presenting at PGDay 2017 to show people the multiple ways they can get involved in the PostgreSQL development project.

With logical replication, DBAs have the ability to control replication by table or by database.

By using a BRIN index instead of a BTREE index for certain queries, you can get huge index size savings with very similar performance.

As a member of the PostgreSQL Global Development Group, we'd like to congratulate the community for the release of PostgreSQL 10.

PDDay Australia 2017 is a one-day conference designed for the PostgreSQL community scheduled for Friday, 17 November 2017 at Rydges Hotel in Melbourne.

Fujitsu incorporated PostgreSQL into its enterprise data management platform to benefit our growing number of customers giving Open Source Software (OSS) first consideration when implementing a new system.

I was asked recently where PostgreSQL actually stores its data on disk. So I thought I’d share this.

I noted there are many aspects of PostgreSQL crucial to the ongoing performance and availability of a database about which a Dev team may not be familiar.

In June 2017, the Fujitsu World Tour touched down in Auckland and Melbourne with FAST exhibiting PostgreSQL-based enterprise database services and solutions.

The annual PGCon is a major event on the PostgreSQL calendar. This year’s conference, sponsored by Fujitsu, took place over four days at Ottawa University.

Haribabu Kommi, Senior Software Development Engineer at FAST, shares his insights into the PostgreSQL community and what he hopes to achieve at PGCon 2017.

Fujitsu was proud to be a Platinum sponsor of pgDay Asia 2017, which comprised talks by several high-quality speakers from the worldwide PostgreSQL community.

Managing in-house support of your PostgreSQL database requires more investment of time and money than you think. Let’s take a closer look at what’s involved.

Fujitsu Australia Software Technology are Platinum Sponsors of the pgDay Asia 2017 Conference.

Tired of constantly running checks on your PostgreSQL activity as it happens? Save time and energy with \watch.

Bring the strength of Elasticsearch to your next PostgreSQL project – it’s surprisingly easy to enhance your PostgreSQL search power.

Extensions are a great way to broaden the functionality of PostgreSQL. One of the most popular is PostGIS.

Protecting clients' data has long been an immediate concern of mine as it probably is for you. Which is why I'm excited by Data Masking (also known as Data Redaction).

Keeping a step ahead of data thieves is an ongoing battle. Thankfully we have an impressive weapon on our side – encrypted tablespaces.

Your PostgreSQL database is no doubt reliable and doing the job well. However, there’s always room for improved performance. Here's five great places to start.

Here are five of the most common threats to your enterprise data.