PostgreSQL — A multi purpose underrated open source database capable of handling RDMS, Analytics and NoSQL functionalities
Postgres 13.1 beta released — https://www.postgresql.org/about/news/2040/
PgConf 2020 on going — https://www.pgcon.org/2020/
PgConf 2020 India — https://pgconf.in/conferences/pgconfin2020/schedule/events
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
https://www.pgcon.org/events/pgcon_2020/schedule/speaker/84-oleg-bartunov/
http://www.sai.msu.su/~megera/postgres/talks/jsonb-roadmap-pgcon-2020.pdf
https://www.compose.com/articles/faster-operations-with-the-jsonb-data-type-in-postgresql/
ZedStore — Columnar Storage — as like Cassandra
TimeScaleDB — Timeseries Database
https://blog.timescale.com/blog/building-a-distributed-time-series-database-on-postgresql/
https://www.pgcon.org/events/pgcon_2020/schedule/session/58-time-series-databases-a-deeper-look/
DB for Analytics
http://www.silota.com/docs/getting-started/postgres-vs-mysql-database-analytics.html
Virtual Computed Columns
https://rob.conery.io/2019/10/24/virtual-computed-columns-in-postgresql-12/
Advanced Indexing
https://sharetechlinks.com/tags/98/postgre-sql?page=1
Advanced Full Text Search
https://rob.conery.io/2019/10/29/fine-tuning-full-text-search-with-postgresql-12/
Materialized Views
https://www.postgresql.org/docs/9.3/rules-materializedviews.html
Using Postgres as a Queue — 10,000 jobs per second
https://gist.github.com/chanks/7585810
Some more links accumulated here
