Re:PostgreSQL 11 Released
by truth_seeker on Thursday October 18, 2018 @01:11PM
(#18250120)
PG works okay with Peta Bytes of data. Various types of indexes, Table partitioning and parallel query computation can help.
Citus and other community extensions can help if you want to go distributed and fault tolerant
Re:PostgreSQL 11 Released
by jacques_chester on Thursday October 18, 2018 @11:41PM
(#18254095)
Worth noting that the Greenplum team are working to converge back to mainline.
1) You need an embedded relational database with a small foot print. Here PostgreSQL cannot compete with SQLite.
2) You have an application which does not support PostgreSQL.
3) You have petabytes worth of data. Here you want to look into something like Greenplum, a PostgreSQL fork.