In software industry if a
project comes to engineer, 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 an open source database. Most of the
operations of PostgreSQL are similar to Oracle.
Here I discovered the main advantage of PostgreSQL. It is little bit faster than
Oracle in fetching data. I tested with same records of data and on same
machine. Loot At Here -
PostgreSQL
Oracle
The same query runs in PostgreSQL in 31ms
(Milliseconds) 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.
No comments:
Post a Comment