How many billion rows of data I can store in PostgreSQL RDS.

On 2/21/19 9:08 PM, github kran wrote:

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.

This would be a question for AWS RDS support.

Thank you.

--
Adrian Klaver
adrian.klaver@aklaver.com

On Thu, Feb 21, 2019 at 09:14:24PM -0800, Adrian Klaver wrote:

This would be a question for AWS RDS support.

And this depends also a lot on your schema, your column alignment and
the level of bloat of your relations..
--
Michael

Hi all.

Taking advantage of the topic I would like to know the recommendations
about how to update to a newer Postgres version having all that amount of
data.

Anyone one could share your experience about?

Thanks in advance.

Regards,

Samuel

Just adding that my case it's not a Amazon RDS, it's common server, if I
can say like that...

On Fri, Feb 22, 2019 at 5:48 AM Samuel Teixeira Santos <arcanosam@gmail.com>
wrote:

Just adding that my case it's not a Amazon RDS, it's common server, if I
can say like that...

Aplologies I missed the point to mention that this is a question to
PostgreSQL community. We are currently using PostgreSQL. ( Aurora Postgres
RDS). I want to know what postgresql can handle in terms of limitations.

Thanks.

On 2/22/19 4:46 AM, github kran wrote:

On Fri, Feb 22, 2019 at 5:48 AM Samuel Teixeira Santos
<arcanosam@gmail.com <mailto:arcanosam@gmail.com>> wrote:

Just adding that my case it's not a Amazon RDS, it's common server,
if I can say like that...

Aplologies I missed the point to mention that this is a question to
PostgreSQL community. We are currently using PostgreSQL. (  Aurora
Postgres RDS). I want to know what postgresql can handle in terms of
limitations.

Aurora Postgres is a fork of the community version:

https://aws.amazon.com/rds/aurora/

"Amazon Aurora is a MySQL and PostgreSQL-compatible relational database
built for the cloud, ..."

You will need to ask the folks that created the fork(AWS) what it's
capabilities are.

Thanks.

--
Adrian Klaver
adrian.klaver@aklaver.com