Re: How different is AWS-RDS postgres?

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How different is AWS-RDS postgres?
Date: 2021-05-26 18:24:33
Message-ID: da7d6a46-40d9-9262-4202-0ff017fe85cb@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>> My question is:
>> Should I be surprised that the initial bulk loaded table is nowhere
>> to be seen, given the thumbs up from the logs?  Is this frailty
>> inherent in AWS/RDS infrastructure?
>>
>> Since this is an academic exorcise, I have minimal AWS support, which
>> has yet to chime in on this matter. My access to the logs is um, er,
>> constrained.
>
> The big differences I notice are:
>
> 1. "postgres" is not a superuser,
> 2. viewing logs is a hassle.
>
> Otherwise, they're really similar.  We've pumped about 6TB of data
> into an instance, and it's been rock solid.  JBoss is quite happy, and
> there haven't been any problems.
>
> --
> Angular momentum makes the world go 'round.
Good to hear.
I pushed this same data set into our previous server (Version 10) so I
was surprised it blew up this time, though in that case these separate
files were more spread out in arrival time.  Nothing in the (available)
logs other that lots of auto-vacuuming  and the suggestion to increase
wal size (which I thought a little surprising).  I really would like to
know just what went south but that isn't obvious yet - OOM?, network?,
disk full? but I can't find any smoking gun on the AWS/RDS pages.

rjs

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2021-05-26 18:52:14 Re: How different is AWS-RDS postgres?
Previous Message Ron 2021-05-26 18:01:51 Re: How different is AWS-RDS postgres?