Explore how PostgreSQL can help achieve data sovereignty through flexible, secure deployments and best practices to ensure compliance with global data regulations.
Discover six essential PostgreSQL features to explore in 2026, from temporal constraints to PL/Rust, for enhancing database performance and capabilities.
Optimize PostgreSQL logical replication with a detailed guide on using the CREATE PUBLICATION command for tailored data sharing and enhanced performance.
Tim Steward discusses why he wrote a reference guide for those transitioning to PostgreSQL, packed with practical tips and insights to make your journey smoother and more efficient.
Read how PostgreSQL's query optimizer innovations over the past decade have transformed database performance and efficiency, setting new benchmarks with PostgreSQL 18.
Seamlessly upgrade PostgreSQL subscribers with PostgreSQL 17's new feature that preserves logical replication states, ensuring continuous and reliable data synchronization.
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.
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.
Discover PostgreSQL 18's new feature enabling logical replication of stored generated columns, enhancing data consistency and replication flexibility across various database scenarios.
Improve PostgreSQL performance by effectively managing dead tuples - but first you must understand their impact and implement efficient remediation strategies.
Leveraging PostgreSQL and SAFe® can transform enterprise databases by enhancing agility, performance, and cost efficiency while overcoming organizational challenges for successful modernization.
Unlock the full potential of PostgreSQL with Design Thinking, Systems Thinking, and Shuhari to drive business growth and innovation.
Discover how Fujitsu's PostgreSQL team made impactful contributions in 2024, driving innovation and supporting the PostgreSQL community's growth.
Join the Fujitsu Enterprise Postgres team at FOSSASIA Summit 2025 in Bangkok to explore PostgreSQL innovations and connect with the vibrant Asia-Pacific open-source community.
Discover PostgreSQL's Access Method interface for indexes, which empowers users to create custom index types for optimized data storage, retrieval, and query performance.
PostgreSQL's B-Tree indexes enhance performance through concurrency improvements, efficient storage, and advanced features like HOT updates, index deduplication, and automatic page deletion.
Learn how to optimize PostgreSQL performance by effectively tuning Background Writer parameters.
Learn how to quickly reinstate a former primary using pgBackRest in Fujitsu Enterprise Postgres, minimizing downtime and primary load.
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.
Learn how to effectively benchmark PostgreSQL using the DBT3 toolkit, simplifying TPC-H benchmarks for complex decision-support queries and large datasets.
Learn about PostgreSQL's Write-Ahead Log (WAL) and its critical role in ensuring data consistency, reliability, and performance in modern database management systems.
In this article I will discuss the intricacies of PostgreSQL row storage, and how it can optimize performance and efficiency with detailed insights into page layout and data management.
Enhance security in Fujitsu Enterprise Postgres with ldap2pg integration. Discover streamlined role management, improved compliance, and reduced administrative overhead.
Exploring the essentials of PostgreSQL B-Tree indexes, their mechanics, and how to use the pageinspect extension for detailed examination.
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.
Fujitsu OSS PostgreSQL team to present at PGConf India 2025, showcasing innovations in Write-Ahead Logging, replication clusters, and failover slots.
Learn how to automate and optimize table partitioning in Fujitsu Enterprise Postgres using the pg_partman extension for improved performance and easier data management.
Discover the enduring legacy and innovation of PostgreSQL, from its beginnings at UC Berkeley to its modern features and enterprise-level stability.
Amit Kapila lists the new features introduced in PostgreSQL 17, and shares his views on what is in store for PostgreSQL 18 and beyond.
Fujitsu Vietnam's Uvance event showcased the benefits of Fujitsu Enterprise Postgres, engaging over 90 participants and highlighting its advantages.
Optimize PostgreSQL performance by configuring shared_buffers, work_mem, and wal_buffers effectively. Learn their importance and how to set them for optimal results.
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.
Discover how PostgreSQL 17's new incremental backup feature in pg_basebackup enhances backup efficiency and simplifies data recovery for large databases.
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.
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.
Fujitsu offers a free Security Assessment for PostgreSQL databases, enabling organizations to evaluate their security against the CIS benchmark with minimal resource impact.
PostgreSQL 16's new load balancing feature in libpq enhances read query scaling and optimizes database performance.
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.
Optimize PostgreSQL with DBtune's AI-driven performance tuning for smarter, dynamic scalability and reduced operational costs.
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!
pgBackRest is intergrated with Fujitsu Enterprise Postgres for efficient, incremental backups and point-in-time recovery, ensuring your data is secure and easily restored.
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 adopts CIS Benchmark to enhance PostgreSQL security, developing advanced guidelines for Fujitsu Enterprise Postgres to maximize data protection and compliance.
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.
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!
Discover the latest updates in PostgreSQL, including new releases, security fixes, and major updates to tools like pgAdmin and Pgpool-II. Stay informed with our comprehensive summary.
Tim Steward uses one of his favorite books as a starting point to discuss the power of PostgreSQL as a purpose driven database.
Learn how to securely implement LDAPS for Fujitsu Enterprise Postgres, ensuring encrypted communication between your PostgreSQL server and LDAP server.
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.
Learn how to upgrade Fujitsu Enterprise Postgres, implement pgBackRest, and enable policy-based login security for enhanced database security and operability.
Our database expert Tim Steward discusses how you can unlock the power of geospatial data to gain valuable insights into natural and human phenomena.
We compared the backup performance of Fujitsu Enterprise Postgres utility pgx_dmpall with PostgreSQL's pg_basebackup in a detailed performance test.
Discover the new features and enhancements in PostgreSQL 16 for improved performance, functionality, and security.
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.
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.
Tim Steward explains how PostgreSQL has emerged as the clear alternative to proprietary databases, backed by a diverse community of developers.
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.
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.
Ajin Cherian writes about the new feature added in PostgreSQL 15 that allows supporting of two-phase commits in logical replication using publications/subscriptions.
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.
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.
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.
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.
Meet Amit Kapila, PostgreSQL Committer and Major Contributor, now leading Fujitsu's PostgreSQL team as Senior Director.
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
In this post, I discuss how PostgreSQL maps the database objects into physical files, and how this affects security in non-encrypted environments.
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.
PostgreSQL could change the database market just as Linux did operating systems. Read how.
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.
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.
Fujitsu Australia Software Technology is a Platinum Partner of this year's PGConf APAC 2018 event. Register early as places are limited.
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.
PostgreSQL proves its rapidly growing popularity by winning Database Management Systems of the Year for 2017 as ranked by DB-Engines.
The growth of your business through digital transformation is supported by Fujitsu as our state-of-the-art technologies offer high reliability and performance.
As a member of the PostgreSQL Global Development Group, we'd like to congratulate the community for the release of PostgreSQL 10.
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.
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.
Fujitsu Australia Software Technology are Platinum Sponsors of the pgDay Asia 2017 Conference.
Extensions are a great way to broaden the functionality of PostgreSQL. One of the most popular is PostGIS.
