EDB Postgres

The Elephant Behind the

The Elephant Behind the Excellence

The Elephant Behind the Excellence 650 486 Exist Software Labs

The preceding year, 2021, was an eventful year for EXIST Data Solutions: new team members were added, new technologies were learned, and new projects were implemented.

In the enterprise database front, PostgrEX was implemented in a prestigious 5-star hotel and casino, a state university, and a major security agency handling the biggest mall in the country.

YugabyteDB, the No. 1 cloud-native, distributed SQL database in the world, was implemented in 3 government projects, and premium EnterpriseDB support was rendered to the country’s primary energy market corporation.

On the data analytics front, Greenplum was also successfully implemented in 3 government projects, thereby enabling these entities to turn their data into actionable insights.

But what do all these business-transforming technologies have in common? In a word: Postgres.

Postgres is the database engine upon which PostgrEX, YugabyteDB, EDB, and Greenplum are based. With most of them, modifications in varying degrees were done to core Postgres to deliver a product that is still Postgres, but better!

As indicated in the article, Databases in 2021: A Year in Review, the dominance of Postgres in the year 2021 was undeniable:

The conventional wisdom among developers has shifted: PostgreSQL has become the first choice in new applications. It is reliable. It has many features and keeps adding more. In 2010, the PostgreSQL development team switched to a more aggressive release schedule to put out a new major version once per year (H/T Tomas Vondra). And of course, PostgreSQL is open-source.

PostgreSQL compatibility is a distinguishing feature for a lot of systems now. Such compatibility is achieved by supporting PostgreSQL’s SQL dialect (DuckDB), wire protocol (QuestDB, HyPer), or the entire front-end (Amazon Aurora, YugaByte, Yellowbrick). The big players have jumped on board. Google announced in October that they added PostgreSQL compatibility in Cloud Spanner. Also in October, Amazon announced the Babelfish feature for converting SQL Server queries into Aurora PostgreSQL.

One measurement of the popularity of a database is the DB-Engine rankings. This ranking is not perfect and the score is somewhat subjective, but it’s a reasonable approximation for the top 10 systems. As of December 2021, the ranking shows that while PostgreSQL remains the fourth most popular database (after Oracle, MySQL, and MSSQL), it reduced the gap with MSSQL in the past year.

Another trend to consider is how often PostgreSQL is mentioned in online communities. This gives another signal for what people are talking about in databases.

What does all this mean for you and your business? It means you can entrust your most mission-critical applications to Postgres and its derivatives; it means you can break free of vendor lock-in and redirect cost savings to core business initiatives; it means your company can be a better version of itself–a more profitable version–in the year 2022!

Contact us and find out how EXIST Data Solutions can meet all your database-related requirements.

Exist is your data solutions partner of choice!

Explore the next level of your digital transformation journey with big data and analytics. Let’s look at opportunities to better maximize your ROI by turning your data into actionable intelligence. Connect with us today, and we’ll proudly collaborate with you!

Exist Provides Tech Spark 768x487 1

Exist Provides Tech Spark For Major Renewable Energy Project

Exist Provides Tech Spark For Major Renewable Energy Project 768 487 Exist Software Labs

MANILA, Philippines  — Exist, a global consulting and enterprise IT solutions leader, is currently working on the development of the country’s landmark nationwide system to establish the country’s renewable energy market (REM).

Faced with a tight bid schedule which threatened the 2019 project timeline, the Philippine Electricity Market Corporation (PEMC), the governance arm of wholesale electricity spot market (WESM) has finally found its worthy IT partner to help design and build the platform and all accompanying technical systems to run the Philippine Renewable Energy Market System (PREMS) that seeks to promote more RE-based investment locally.

“We are honored for the trust that was given to our team, for believing in our enterprise IT skills and experience to provide solutions for the local energy sector”, reveals Mike Lim, CEO of Exist.  “Working on PREMS and previously on the WESM spot market system afforded us a unique perspective and as a result, we can say we have a better understanding of the local power sector and a bountiful supply of ideas for innovative solutions that could help market participants, as well.”

Under the joint auspices of the United Nations Development Program (UNDP), the Department of Energy (DOE) and the Global Environment Facility (GEF) called Development for Renewable Energy Applications Mainstreaming and Market Sustainability (DREAMS) Project, the development of PREMS is intended to curb local greenhouse gas (GHG) emissions through commercialization of the RE markets and incentivize investments in RE-based power generation projects.

“We’ve assembled our best software minds and utilized knowledge of up and coming technologies to ensure that we deliver a complete system that is perfectly capable to carry out PREMS’ supportive policies and regulatory requirements”,  adds Mr. Lim. “As per practice, we keep close coordination with all partners concerned, working out changes to ensure that we still deliver within schedule.”

In 2008, The Philippine Renewable Energy Act was passed which aimed to elevate the use of renewable energy resources and its capacity development yet in many ways, adoption and preferential use of RE is still very much in a transition phase.

Mr. Lim further adds, “We are aware of the significance of this project, not only for its alternative power-providing component but for the focus this brings towards a cleaner environment and a sustainable future.”

We cannot afford any more delays. We understand this is also about doing our part as a nation to contribute towards the health of our planet”, concludes Mike.

You can view the official UNDP Procurement Notice for the Development of Software, Supply and Delivery of Hardware for the Implementation of the Philippine Renewable Energy Market System (PREMS) awarded to Exist here. (http://procurement-notices.undp.org/view_awards.cfm)

Exist Ashnik and EnterpriseDB Present Postgres Powers Digital Transformation in Southeast Asia – Success Stories at the Future Energy Show Philippines 2019 768x487 1

Exist, Ashnik and EnterpriseDB Power Digital Transformation for the Philippine Electricity and Power Sector

Exist, Ashnik and EnterpriseDB Power Digital Transformation for the Philippine Electricity and Power Sector 768 487 Exist Software Labs

At the recently concluded The Future Energy Show Philippines 2019, Exist, Ashnik and EnterpriseDB teamed up to highlight the advantages of using Postgres for a number of IT projects specifically within the electricity sector.

During the 2-day event, booth visitors and fellow sponsors personally listened to the stories about how Exist, Ashnik and EnterpriseDB were able to provide their skills and expertise for the local energy sector which began not too long ago.  

With years of experience working on enterprise systems across a diverse range of industries from banking and finance to retail and healthcare, Exist was able to get the opportunity and win the trust of the main local energy corporations PEMC and WESM for developing mission-critical systems required to bring the electricity spot market closer to achieving its goal of having a transparent, fair, competitive, and reliable market for the trading of electricity throughout the Philippines.

Working closely with Ashnik as a partner, the push for the use of EDB Postgres has always made the most sense as the choice of database with the balanced mix between cost and features that make it the most complete open source-based data platform.

One of the highlights of our participation at the event is our talk entitled “Postgres Powers Digital Transformation in Southeast Asia – Success Stories”, presented by Rekha Ramaswamy, Enterprise Sales Manager at Ashnik and Jenish of Vyas, Solutions Engineer, SE Asia and Hong Kong at EDB Postgres. In this session, they shared compelling business cases and customer success stories highlighting the value of the open source-based EDB Postgres Platform in helping enterprises confidently deliver on the promise of digital business.

“Based on the open source Postgres platform, we’ve enhanced it in such a way that it has additional application security and improved performance. [In using EDB Postgres] we are not compromising on existing features but giving added flexibility with [their] existing legacy database.”
Jenish of Vyas, Solutions Engineer, SE Asia and Hong Kong at EDB Postgres

Check out the slides and videos below:

EDB Postgres Philippines 768x487 1

The EDB Postgres Platform Means “Enterprise” Need Not Cost an Arm and a Leg

The EDB Postgres Platform Means “Enterprise” Need Not Cost an Arm and a Leg 768 487 Exist Software Labs


A piece of software is enterprise-grade when it caters to the needs of not a single individual, nor a select group of individuals, but the whole organization. When applied to database management systems, an enterprise database is an implementation of database software that serves the organization by managing their humongous collection of data. It must be robust enough to handle queries from hundreds to tens of thousands of users at a time. It must also have a host of features that are geared towards improving the productivity and efficiency of the organization, such as multi-processing, parallel queries, and clustering, to name a few.

For many organizations, the choice, when it comes to the selection of an enterprise database management system, has been Oracle (even MS SQL Server). To be sure, Oracle is a very capable enterprise DBMS, but at what cost?

As the title of this article suggests, it need not cost an arm and a leg. Why should it when you have the EDB Postgres Platform, the only open source-based enterprise DBMS with native Oracle compatibility?

Oracle Compatibility?

When you subscribe to EDB Postgres Enterprise, you get the EDB Postgres Advanced Server, the heart of the EDB Postgres Platform.

But first, a few brief definitions are in order.

What is the EDB Postgres Platform? According to the definition on the official EDB website: “The EDB Postgres Platform provides an enterprise-class data management platform based on PostgreSQL, including toolkits for management, integration, and migration; flexible deployment options; and services and support to deploy Postgres responsibly at scale.”

Dummy Image

What is an EDB Postgres Enterprise subscription? Again, according to the official website: “The EDB Postgres Enterprise subscription includes the use of EDB Postgres Advanced Server, EDB’s enhanced Postgres distribution with enhanced security, enterprise tooling for DBAs and application developers, and Oracle database compatibility.”

And now to the heart of the matter, what is EDB Postgres Advanced Server? Where better else to turn than, once again, the official website:

“EDB Postgres Advanced Server is EDB’s enhanced Postgres database designed to meet the needs of the digital enterprise.

  • EDB Postgres Advanced Server incorporates all of PostgreSQL’s features with additional enterprise-class functionality for enhanced performance and security requirements for enterprise workloads.
  • EDB Postgres Advanced Server features improve DBA and developer productivity.
  • Oracle users benefit from EDB Postgres Advanced Server’s native database compatibility with Oracle, including PL/SQL, built-in packages, and many DBA tools to accelerate and simplify migrations.”
Dummy Image

That last bullet point is where we want to dwell. Simply put: Because EDB Postgres Advanced Server is an enterprise-class database that is natively compatible with Oracle, your organization can enjoy enterprise-class database management services at a drastically more cost-efficient manner by moving away from Oracle onto the EDB Postgres Platform.

This movement away from Oracle can take the form of outright migration of current Oracle databases to EDB Postgres Advanced Server. It can take the form of offloading Oracle reporting jobs to EDB, thus freeing up resources for Oracle OLTP. Operational data stores? New applications development? You don’t have to buy new (and very costly!) Oracle licenses for these initiatives when EDB Postgres Advanced Server can do the job just as well, at a fraction of the cost!

According to the whitepaper entitled, “EDB Postgres Advanced Server Database Compatibility for Oracle”, EDB Postgres Advanced Server is compatible with Oracle in the following way:

EnterpriseDB extends PostgreSQL to implement the same functionality as Oracle DB primarily with data type support, selected PL/SQL compatibility, Oracle SQL syntax, and built-in SQL functions. DBAs have similar catalog views, wait events and compatible tools such as EDB*Plus and EDB*Loader. Developers have access to popular packages for fast development, advanced object type functionality, object-oriented programming support and programming features such as bulk collections and SQL hints.

Addressing Resistance to Emancipation

There are 3 primary reasons why organizations may pose some hesitation to experiencing freedom from Oracle:

1. Technical Risks. Anxiety over whether EDB Postgres Advanced Server can do the job as relating to database features.

2. Re-training Risks. The pain points of learning new technology.

3. Integration Risks. Issues pertaining to the assimilation of new technology in the I.T. infrastructure.  

How does the EDB Postgres Platform mitigate these risks?

1. Technical Risks.

The EDB Postgres Platform addresses data compatibility issues through the EDB Migration Toolkit.

According to the official website, “EDB’s Migration Toolkit (MTK) migrates tables, data, stored procedures (Oracle only) and custom developed packages (Oracle only) from SQL Server, Sybase, Oracle and MySQL to EDB Postgres Advanced Server.”

Dummy Image

In terms of code compatibility, EDB Postgres Advanced Server executes PL/SQL stored procedures, triggers, packages, and understands extensions like DUAL, Rownum, Decode, NVL(2) and Substr(). Its execution of PL/SQL is not emulation, translation, nor a layer on top of PL/pgSQL. Its procedural language is compiled, interpreted, and debugged just like in Oracle. For database code embedded in client programs, it has ECPGPlus (Pro*C support). Oracle’s OCI (Oracle Call Interface) is supported through EDB’s OCL (Open Client Library).

There are tools included in the EDB Postgres Platform that support mission-critical applications, such as Postgres Enterprise Manager (provides much of the same functionality DBAs use in Oracle Enterprise Manager) for monitoring, managing, tuning, and alerting. High-availability and failover are handled by EDB Failover Manager along with the binary replication and hot standby features (similar to Oracle’s Active Data Guard).

2. Re-training Risks.

Oracle users migrating to EDB Postgres Advanced Server need not worry that their current Oracle skill sets will go to waste.

Oracle developers can still code in PL/SQL. They can still use query hints (default optimizer hints, access method hints, join order hints, join relation hints, global hints, append hints). The following packages are still available to them: DBMS_ALERT, DBMS_CRYPTO, DBMS_JOB, DBMS_LOB, DBMS_LOCK, DBMS_OUTPUT, DBMS_PIPE, DBMS_PROFILER, DBMS_SCHEDULER, DBMS_SQL, DBMS_RANDOM, DBMS_RLS, DBMS_UTILITY, UTL_ENCODE, UTL_FILE, UTL_HTTP, UTL_MAIL, UTL_SMTP, UTL_URL, and custom packages. Virtual private databases can be implemented using a package compatible with Oracle’s DBMS_RLS (row level security).

Oracle DBA’s will thoroughly appreciate the following tools at their disposal:

  • EDB’s Resource Manager (CPU & I/O resource allocation). Similar to Oracle’s Resource Management and Profile.
  • EDB’s password profiles (profiles for password management). Provides Oracle compatible user account and password policy management functions. DB-level security rules are migrated from Oracle to EDB Postgres Advanced Server.
  • The ability to capture, review, and diagnose “Wait” events in DB processing through EDB Postgres Advanced Server’s DRITA (Dynamic Runtime Instrumentation Tools Architecture) functions.

Functions: get_snaps(), sys_rpt(), sess_rpt(), sessid_rpt(), sesshist_rpt(), purgesnap(), truncsnap()

Statspack-like AWR (automatic workload repository) reports: edbreport(), stat_db_rpt(), stat_tables_rpt(),              statio_tables_rpt(), stat_indexes_rpt(), statio_indexes_rpt(), edb$system_waits, edb$session_waits, edb$session_wait_history

Catalog views: edb$system_waits, edb$session_waits, edb$session_wait_history

  • EDB Postgres Advanced Server includes over 50 of Oracle’s most popular dictionary views (Catalog views), including all DBA_views and USER_views.
  • EDB Postgres Advanced Server supports Oracle’s table partitioning syntax.
  • EDB*Plus – command line tool for working directly with the database which is nearly indistinguishable from its Oracle counterpart.
  • EDB*Loader – for bulk data loads and provides support for direct path and parallel direct path loading.

3. Integration Risks. 

With EDB Replication Server, replicating and migrating data to and from Oracle becomes a breeze.

From the official website: “EDB Replication Server (EPRS) provides a robust data replication platform that replicates between Postgres databases in a single-master or multi-master mode, or from non-Postgres databases to Postgres in a single master mode. EPRS provides geographic load balancing, simplifies real-time migration, and enables heterogeneous data integration.”

Dummy Image

EDB Postgres Advanced Server can participate with Oracle in XA, multi-database, 2-phase commit transactions by virtue of its XA resource manager.

With EDB Postgres Advanced Server’s implementation of the SQL/MED (Management of External Data) standard, foreign data wrappers for MySQL, MongoDB, and Hadoop make quick work of integrating website and NoSQL data into a relational data store. Many other foreign data wrappers that work with the Postgres ecosystem also work with EDB Postgres Advanced Server, like LDAP, ODBC/JDBC, File/CSV, Twitter/Facebook.

Dummy Image


What all this tells us is that the EDB Postgres Platform is compatible with:

1. Your technology (No application rewrites)
2. Your people (Minimal re-training)
3. Your business (Easy integration)

Inexpensive database compatibility with Oracle means that it is compatible with any organization’s Oracle technology, technical staff, and I.T. business infrastructure.

By reducing technology, re-training, and integration risks, it removes barriers to change, thereby enabling organizations to transform their I.T. infrastructures and freeing up the budget for building new applications of innovation and customer engagement. Hold on to your arm and leg and migrate to the EDB Postgres Platform. The strength and speed of your business depend on it.

web 800x507 The Future is Open EDB Postgres and Your Enterprise Data 768x487 1

The Future is Open: EDB Postgres and Your Enterprise Data

The Future is Open: EDB Postgres and Your Enterprise Data 768 487 Exist Software Labs


The trend of adopting open source technologies by enterprise-grade organizations remains on the rise. This is markedly true in the area of database technologies.

Consider the following forecasts by Gartner with regard to the continuous adoption of open-source technologies and Open-source DBMS (OSDBMS):

“By 2019, OSDBMS technology will account for more than 10% of DBMS spending, reflecting accelerating adoption by enterprise users.

By 2022, more than 70% of new in-house applications will be developed on an OSDBMS, and 50% of existing commercial RDBMS instances will have been converted or will be in process of converting.

Through 2020, relational technology will continue to be used for at least 85% of new applications and projects.

Through 2020, open-source software in IT portfolios will increase at a 30% compound annual growth rate.

By 2022, more than 60% of all global organizations will improve their internal skills related to open source to enable better use of open source in production, which represents an increase from 20% in 2018.” [note]Gartner, State of the Open-Source DBMS Market, 2018, 02-28-2018[/note]

EDB Postgres: The viable OSDMS alternative to proprietary and commercial solutions.

Postgres has been the RDBMS of choice of many government and private enterprises for over 25 years. Government agencies depend on Postgres to deliver robust, secure applications for the public. In private companies, industries included in the extensive Postgres portfolio include financial services, insurance, health care, energy, media, retail, telco and pharma.[note]Which Postgres Is Right For Me?[/note]

The following signify the reasons for this confidence in Postgres:

Robust OLTP engine – Postgres’ database engine combines ACID transaction guarantees with referential integrity, advanced subquery processing and other enterprise-class features.

Rich, expressive data types – Postgres supports a broad range of data types, including multi-dimensional arrays and user-defined types. Postgres also provides indexing and query operations on JSON data, matching or exceeding the functionality of NoSQL document stores for many use cases.

Advanced concurrency control – Postgres maintains data consistency through multiversion concurrency control (MVCC), allowing database read and write operations to execute optimistically, without blocking each other.

Stored procedure flexibility – Postgres has loadable modules that enable database developers to write stored procedures in popular programming languages such as Java, C, Perl, Python, Ruby and even JavaScript.

Community ecosystem – In addition to delivering bug fixes and enhancements for the core Postgres database, the extended Postgres community provides a broad range of add-on products and services. [note]ibid[/note]

It is undeniable that Postgres is uniquely poised to act as the open source database backend for many sophisticated applications. However, many organizations require the enterprise class features and support that are missing in the community version.

EDB is the global leader in providing enterprise-class products and services for Postgres users.

EDB’s collaborative efforts within the Postgres community have been going on for over 10 years, initiatives that include the funding of research projects and contribution of core database functionality to the open source code base. As a highly-esteemed community partner, it is a major influence in the future direction of Postgres.

EDB offers two Postgres-based product subscriptions:

EDB Postgres Standard (EPS) – This subscription, based on the open source PostgreSQL database, provides technical support and mission-critical tools needed for enterprise class deployments. EPS is generally geared toward departments and smaller organizations building mixed-workload applications.

EDB Postgres Enterprise (EPE) – Leveraging the Postgres database core, EPE combines enterprise technical support SLAs and product roadmap influence with a wealth of high- value product features. EPE is geared toward organizations that need to build and manage durable, scalable, high performance database applications. EPE also includes advanced security and performance features in addition to a renowned suite of Oracle® compatibility capabilities that accelerate Postgres adoption in Oracle shops. [note]ibid[/note]


business value of EDBPostgres

Referencing the IDC (International Data Corporation) report entitled, The Economic and Business Advantages of EDB Postgres Database Solutions, wherein key organizations that have adopted EDB Postgres were assessed, it was determined that benefits in the following areas were realized: Business Value, DBA Staff Efficiencies, and Database-Related Costs.

Realizing Business Value With EDB Postgres

Lower cost-of-operation expenses (42% lower across three years) by virtue of the elimination of database-related licensing fees and lower maintenance costs (EDB’s opex-based pricing model as opposed to capex-weighted licensing models) enabled organizations to be more flexible and scalable in their use of database technology, thereby lending reliability and performance to the solutions that support their business operations.

The following are the ways these organizations are realizing value by leveraging EDB Postgres as a high-performance, cost-efficient database platform to better capitalize on business opportunities:

Scalability – EDB Postgres enables organizations to scale their database resources to match business demand. In particular, organizations do not face limitations imposed by up-front capex costs when they need to build new databases or expand a database. A database manager explained: “The scalability of EDB Postgres is a real benefit. We just started with the platform for customers to do queries on our databases, and we can very easily scale this up and down depending on the demand of our clients, which is difficult to predict. We shoot to be flexible and offer high scalability, and EDB Postgres can do this against relatively low costs. It would be far more difficult with another platform.”

Flexibility – EDB helps organizations avoid vendor lock-in by providing an open 
source–based alternative to other database solutions and gives them more flexibility to find database solutions that match their business and operational needs. A database manager commented: “We are always looking for alternative technology just in case our current technology proves to be a dead end or bottleneck in performance, which led us to EnterpriseDB.”

Cost impact – Beyond paying less for their database environments, organizations can embed lower database costs in their pricing and better compete because the overall cost of operating EDB Postgres databases is lower than the overall cost of operating their previous or alternative solutions. A database manager explained: “We are better able to sell to new customers in this new space. Without EDB Postgres, we could go after them, but we wouldn’t win them.”

Integration – EDB Postgres offers the ability to integrate with a number of Big Data analytics solutions, which can enable application development efforts and help tie Big Data analytics more closely to improved business and operational outcomes. A database manager noted: “As we come up with crazy query requirements for our application development, it’s easier to get [them] done and faster with EDB Postgres.” [note]The Economic and Business Advantages of EDB Postgres Database Solutions[/note]

These EDB Postgres attributes paved the way for the following positive business results:

More revenue and more customers – A database manager at one interviewed organization explained: “EDB Postgres allows us to be not only the best provider in the world but the lowest-cost provider. That’s the best way to describe it … We’re bringing in substantially more revenue because it has allowed us to take new contracts.”

Increased database functionality – Another database manager commented: “EDB Postgres gives us the ability to expand the type of databases that we’re actually interacting with. In that sense, it gives us a flexibility that says I don’t have to be tied to this other database or a particular database. We can do functionality in multiple databases. For us, that’s key. It gives us flexibility.” [note]ibid[/note]

As a result of EDB Postgres being a reliable and robust database platform, these organizations have also reported fewer unplanned, database-related outages and shorter resolution times (62% lower impact of such unplanned outages on their operations with EDB Postgres over three years).

Achieving DBA Staff Efficiencies

Another benefit realized was in the area of database administration. The ease of deployment and management of EDB Postgres environments resulted in an average of 15% less deployment, configuration, maintenance, and administration time, measured in a span of  three years, as compared to competing database technologies (16% more efficient administration). The respondents reported that it was the platform’s simplicity that undergirded these improvements.

As a database manager at one organization noted:

“There is a significant difference in DBA staff time with [our alternative database environment] — 10 hours per week with EDB Postgres compared with 40 hours per week previously … EnterpriseDB is a much simpler model and is built to be operated without dedicated operators — it’s not built on the premise of having people with deep knowledge about the database.” [note]ibid[/note]

Reducing Database-Related Costs

It is precisely in two areas that EDB Postgres showcases maximum profitability in terms of database-related costs:

  • No exorbitantly-priced, up-front licensing costs. This is particularly the bane of the majority of commercial database solutions.
  • Lower annual subscription rates. This translates to cost savings realized across more than three years in comparison to the organization’s prior or competing traditional or open source database technologies.


Adopting EDB Postgres, either as a greenfield implementation or migration initiative, is not a mere instance of jumping on the open-source bandwagon. While it is a fact that many may have had to settle for trade-offs in moving to open-source database management systems, trade-offs in terms of performance degradation and awkward administration for lower cost, this is never the case for any organization that decides to embrace EDB Postgres.

In fact, these organizations will reap the benefits of their systems running faster, easier to administer, and providing more flexibility than the systems they had used previously. EDB Postgres, aside from providing the standard benefits of open source, is the go-to solution to the problem of expensive, unduly complex, and poor performing database platforms.

EDB Postgres is the future.