Oracle Vs PostgreSQL -Which is Faster?

In software industry if a project comes to engineer to develop first thing comes in his mind which language to be use. And the second and most important thing which database should use? There are several databases in market. Some are paid and reaming open source. Many people go for open source because no need to pay or invest huge amount. Oracle is the famous and most running database in market which is a paid database. PostgreSQL is similar to Oracle which is a open source database. Most of the operations of PostgreSQL are similar to Oracle.

Here I discoursed the main advantage of PostgreSQL is it is little bit faster than Oracle in fetching data. I tested with same records of data and on same machine. Here, which I found the difference.

PostgreSQL

Oracle

The same query runs in PostgreSQL in 31ms (Miliseconds) and oracle in 55ms. In Oracle if we want to check its data type we have to type a command ‘DESC TABLENAME’. But in PostgreSQL it is coming in ‘SELECT * FROM TABLE NAME’. Just see the images above.