Postgres Pro
Downloads
Home   >   mailing lists

How many billion rows of data I can store in PostgreSQL RDS. - Mailing list pgsql-general

From github kran
Subject How many billion rows of data I can store in PostgreSQL RDS.
Date
Msg-id CACaZr5QwGZanRdbrTQVvLO5vVN8EzK3prjhz1QVHU9sWGZLCRw@mail.gmail.com
Whole thread Raw
Responses Re: How many billion rows of data I can store in PostgreSQL RDS.  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Hello Pgsql-General,

We have currently have around 6 TB of data and have plans to move some historic datainto RDS of about close to 1 TB of data. The total rows in partitioned tables is around 6 billion rows today and have plans to keep the data long term which would be around 5-8 billion rows per year. 

So i short my use case is to keep data of 8 billion rows of data every year and store atleast 16 billion of rows for every 2 years. 
  1. How many billion rows does RDS handle ?. This data would be exposed by AP's accessing this data.
Appreciate you reply on this.
Thank you.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG Upgrade with hardlinks, when to start/stop master and replicas
Next
From: Adrian Klaver
Date:
Subject: Re: How many billion rows of data I can store in PostgreSQL RDS.