Open source RDBMS: When To Use PostgreSQL

Given a choice to look for open-source RDBMS which provides most of the persistent capabilities, PostgreSQL comes as the one of the preferred database for the architects. Here in the blog, we will walk you through the cool features PostgreSQL provides and how it supersedes the other available DBMS systems.

Silent Features : 

1. Free, Open-source, ACID/SQL compliant. This is where it is advantageous over MySQL which is partially sql complaint.
2. Replication
1. Logical: Sends only row changes and only for committed transactions. Does not send index changes, DDL changes etc.
2. Physical/stream : Sends disk block of changes.
3. Write-Ahead Log shipping: Warm and hot standby servers can be made current when main server fails.
3.  Admin tool: PgAdmin
4. Data types: Support user defined types.
5. Support IP address data types,Partial indexes, Bitmap indexes
6. Widely used in large systems where read and write speeds are crucial and data needs to be validated.
7. For heavy load and running complex queries it works better than MySQL.
8. Has high level of concurrency support.
9. The best thing here is it supports both JSON and noSQL features/native XML .