Hey Jeremy,
Thanks so much for your response. That's a great tip regarding enabling
enhanced monitoring. Maybe it will give some insight into which particular
backends are causing the shutdown to hang. One interesting data point when
this happened is that in cloudwatch, once the database started
On 9/14/18 12:11 PM, Jeremy Schneider wrote:
On 9/14/18 10:04, Christophe Pettus wrote:
Thanks Christophe - even if it's not what Chris is running into, this is
is another good call-out.
It's important to distinguish here between the RDS parts and the
community PostgreSQL parts. I think fo
> On Sep 14, 2018, at 08:43, Jeremy Schneider wrote:
> So yeah, it's not common...
In our experience, it's actually quite common that an RDS shutdown (or even
just applying parameter changes) can take a while. What's particularly
concerning is that it's not predictable, and that can make it
On 9/14/18 8:43 AM, Jeremy Schneider wrote:
Hi Chris - this is an interesting one that we do see from time to time;
seems worth responding here as actually our best understanding right now
is that this is something in community code, not AWS-specific.
On 9/13/18 16:10, Adrian Klaver wrote:
On Thu, Sep 13, 2018 at 7:05 PM Chris Williams wrote:
> We just have a few ruby on rails applications connected to the database,
> and don't really have any long running or heavy queries and the db is under
> very light load, so I don't understand why it takes so long to shutdown.
> We do have a
On 9/13/18 3:59 PM, Chris Williams wrote:
Yeah, I figured that. Unfortunately, every time it happens, I open a
support ticket with them, but they always just tell me that this is
normal behavior for postgres. Whether it's "normal" or not, I really
would like to get my db to shut down faster,
Yeah, I figured that. Unfortunately, every time it happens, I open a
support ticket with them, but they always just tell me that this is normal
behavior for postgres. Whether it's "normal" or not, I really would like
to get my db to shut down faster, and their suggestion of manually shutting
down
On 09/13/2018 03:04 PM, Chris Williams wrote:
Hi,
I'm using AWS RDS Postgres (9.6.6) and have run into very slow
shutdowns (10+ minutes) a few times when making database modifications
(e.g. reboot, changing instance size, etc.). Other times, it shuts
down quickly (1 minute or so). I have no
