Horton

Re: How different is AWS-RDS postgres?

Rob Sargent <robjsargent@gmail.com>

View thread View on postgr.es
From: Rob Sargent <robjsargent@gmail.com>
To: Sam Gendler <sgendler@ideasculptor.com>
Cc: Philip Semanchuk <philip@americanefficient.com>, Ian Harding <harding.ian@gmail.com>, Ron <ronljohnsonjr@gmail.com>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2021-05-28T16:41:46Z
Lists: pgsql-general 
Found it.  Though there are indeed separate transactions for the bulk 
copy  v. target update, I had missed that there is an over-arching 
transaction in play and of course when things go south, /all/ things go 
south.

I get away with this, for now by bumping the tomcat idle time to an 
hour, which is serious overkill.