Re: How different is AWS-RDS postgres?

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Sam Gendler <sgendler(at)ideasculptor(dot)com>
Cc: Philip Semanchuk <philip(at)americanefficient(dot)com>, Ian Harding <harding(dot)ian(at)gmail(dot)com>, Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How different is AWS-RDS postgres?
Date: 2021-05-28 16:41:46
Message-ID: 66bb8e7d-2c2b-3bd0-0ac1-855dbf3b1de4@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laura Smith 2021-05-28 17:56:45 Re: Modelling versioning in Postgres
Previous Message Tom Lane 2021-05-28 16:18:21 Re: TRUNCATE memory leak with temporary tables?