Contents
How big is PostgreSQL database for admissions data?
However, having PostgreSQL as the single source of truth about all data that is being aggregated and all the processes that aggregate the data made it a lot easier. This adds up to 1.2bn records/month, and thats just for the admissions data. We went through several providers:
How to handle 10 million rows in PostgreSQL?
Table has columnSEGMENT_ID INT NOT NULL, where each segment has about 100.000-1.000.000 rows. Writes – all rows for SEGMENT_IDare inserted at once, no updates for SEGMENT_IDafterwards. Reads – are pretty often, I need good performance for SELECT * FROM table WERE SEGMENT_ID = ?.
Why are there so many demands on PostgreSQL?
The reasons for this amount of demands could be temporal, for example, if we’re launching a discount on a sale, or permanent, for an increase of customers or employees. In any case, we should be able to add or remove resources to manage these changes on the demands or increase in traffic.
Can you use Amazon RDS for PostgreSQL database?
Then we secured credits from Amazon and migrated to Amazon RDS for PostgreSQL — their version of PostgreSQL was kept up to date and my research into the RDS community raised no concerns. However, Amazon RDS for PostgreSQL does not support TimescaleDB extension that we planed to use for partitioning of our database.
What does it mean to scale PostgreSQL database?
There are many approaches available to scale PostgreSQL, but first, let’s learn what scaling is. Scalability is the property of a system/database to handle a growing amount of demands by adding resources.
Why did we migrate from Google SQL to PostgreSQL?
We used Cloud SQL for PostgreSQL for about 6 months. The primary reason we migrated away from Google SQL for PostgreSQL is because we discovered a bug that was causing data corruption. This was a known bug that is fixed in newer PostgreSQL versions. However, Google SQL for PostgreSQL is several versions behind.