Re: How different is AWS-RDS postgres?

Rob Sargent <robjsargent@gmail.com>

From: Rob Sargent <robjsargent@gmail.com>
To: Ian Harding <harding.ian@gmail.com>
Cc: Ron <ronljohnsonjr@gmail.com>, pgsql-general@lists.postgresql.org
Date: 2021-05-27T02:04:59Z
Lists: pgsql-general

> On May 26, 2021, at 4:37 PM, Ian Harding <harding.ian@gmail.com> wrote:
> 
> 
> There is an option to send the logs to cloudwatch which makes it less awful to look at them. 
I have that but precious little of interest there. Lots of autovac, a smattering of hints to increase wal size!?  I have yet to spot anything which corresponds to the “I/O failure” which the middle ware gets. 

I don’t have query logging on, but I do see reports from my psql session fat-fingering.

As to the logs UI, the search is pretty feeble; I don’t understand why there are four  channels of logs; the graphs are wearing the same rose-coloured as the logs.  
And 24 hours without a peep from AWS support. (I don’t call mailing me what I sent them “contact”.)

My guess right now is that the entire tomcat connection pool is in a single transaction? That’s the only way the tables could disappear.  I am making separate calls to JDBC getConnection () for each doPost.