PostgreSQL — A multi purpose underrated open source database capable of handling RDMS, Analytics and NoSQL functionalities

Bharat Dwarkani
1 min readMay 28, 2020


Postgres 13.1 beta released

PgConf 2020 on going
PgConf 2020 India

Some advanced not known features which PostgreSQL is capable of

RDMS — as like other Database ACID compliant

NoSQL — Using jsonb — provides native json querying functionalities

ZedStore — Columnar Storage — as like Cassandra

TimeScaleDB — Timeseries Database

DB for Analytics

Virtual Computed Columns

Advanced Indexing

Advanced Full Text Search

Materialized Views

Using Postgres as a Queue — 10,000 jobs per second

Some more links accumulated here



Bharat Dwarkani

Tech Enthusiast, Full Stack Software Engineer, Product Manager, Engineering Enterprise SaaS product