Tag Results

Financial Services Institutions Look to Open Source Today’s financial services institutions must innovate and evolve their technology to remain competitive during a time of great disruption. The need for rapid innovation and increasing digitalization is shining a light on the IT complexity many financial services institutions now face — untangling years of layered legacy systems. Legacy IT systems dominate many large financial services institutions, and it is safe to say that highly customized applications are a major issue. Many financial services […]

SINGAPORE – Media OutReach – 12 March 2018 – PGConf APAC has announced its third user conference, which will be held on March 22–23, 2018 in Singapore. Known to be the only large-scale PostgreSQL conference in Asia Pacific, PGConf APAC aims to create a platform for the developer community to network, exchange ideas, and get better equipped on Postgres. “This event is a part of the effort to grow the PostgreSQL community by increasing awareness and knowledge to enhance PostgreSQL adoption […]

PostgreSQL has long been a popular database, loved by developers and database administrators for its ease of use, comprehensive and intuitive documentation, and reliability. Anyone at EnterpriseDB® (EDB™) could tell you that interest in PostgreSQL (also known as Postgres) has been growing rapidly in recent years, but that might be considered biased. Now, an unbiased source, DB-Engines, has announced that 2017 was a banner year for interest in Postgres. So much so that DB-Engines named Postgres “DBMS of the Year 2017”. DB-Engines is a website […]

As we approach year end, our EDB team was inspired to take a look back at our blog posts from the year and see what topics resonated the most with our readers. Here is a Top 10 recap of your favorites from 2017. 10. Pgpool II Keeps Pace With Demands of Today’s Architectures and Workloads This blog is about Pgpool II, the middleware product that sits between the PostgreSQL server and database clients. Coming in at #10 for 2017, our readers […]

In a recent support case, I came across a customer who used a clever way to create streaming replication base backups–by taking a Google Cloud instance and cloning it. With the proliferation of cloud computing, it’s very convenient to be able to create a block-level clone of a VM within minutes or even seconds, and it would be much faster than any program like scp or rsync. They had found it to be faster than pg_basebackup for sure, on the order of several […]

Use case: Mobile Application with offline first approach One of Ashnik’s customers – a top Insurance company in Asia was looking to develop a mobile application with online & offline capabilities. The needs being: To enable the field agents to access their customers’ insurance related information for read and offline operations Subsequently, sync all the insurance related customer data, captured by the field agents while being offline, back to the data centre  – when the device goes online later The Goal of the […]

Since I just committed the last pending patch to improve hash indexes to PostgreSQL 11, and since most of the improvements to hash indexes were committed to PostgreSQL 10 which is expected to be released next week, it seems like a good time for a brief review of all the work that has been done over the last 18 months or so. Prior to version 10, hash indexes didn’t perform well under concurrency, lacked write-ahead logging and thus were not safe […]

Streaming replication in PostgreSQL can be asynchronous or synchronous. The synchronous option provides greater data protection in case of disaster, or if a server or data center goes down. Synchronous replication does come with a performance penalty, which is why many people use the default asynchronous option if losing some data in case of disaster is not a big issue. For any application such as a financial application that cannot tolerate any data loss, synchronous replication is the answer. Synchronous replication […]

The new EDB Postgres™ Platform 2017 from EnterpriseDB® (EDB™) gives enterprises the capability, performance, and reliability they need with the flexibility and ease of provisioning required by modern DevOps. A core component of the Platform is the EDB Postgres™ Advanced Server database, a version of Postgres that EnterpriseDB has enhanced with enterprise-class performance, security, manageability, and developer capabilities. The new EDB Postgres Platform 2017 rolled out a new version of the database, EDB Postgres Advanced Server 9.6. (Read the press release […]

For the last few weeks, I have been working with a key opportunity of Ashnik – a major Bank in Singapore, on designing a database solution for them. The solution will be based on EDB Postgres and will support one of the key applications for the bank. It can be considered as one of the most ambitious implementations of Postgres in the BFSI segment. On meeting their team for the first time, I realized that the bank is a mature user […]