Why PSQL is not a viable OLAP

[ChakshuGautam]

1. Uber Engineering's Blog on PSQL Limitations
2. Evaluating HA for Postgres

[ChakshuGautam]

Where and why do we use PSQL?

The primary use case of PSQL at GovTech is to use it as a transactional database. As an extension, we also have the same DB with read replicas being used for Visualizations. We have faced countless issues with being able to manage read replicas with the connections getting broken the sync needs to start again. This happens due to the following

• A very small fraction of it is due to the DO networking issues which lead to one of them stop connecting to the other
• Mostly this is due slave not able to find the WAL segment from the primary. Usually, this is due to the checkpointing behavior where WAL segments are rotated or recycled. (We have never been able to find a good enough setting for how long to keep logs - having too