Re: Oracle vs PG

On 10/23/18 1:47 PM, Ravi Krishna wrote:
>>
>> Since the article was almost content-free I not would use it on either
>> side of the argument. The only thing I pulled from it was Amazon
>> changed databases and hit the learning curve. That will happen in
>> either direction.
>
> I agree but this is the key:
>
> "Savepoints are an important database tool for tracking and recovering
> individual transactions. On Prime Day, an excessive number of savepoints
> was created, and Amazon's Aurora software wasn't able to handle the
> pressure, slowing down the overall database performance, the report said."
>
>

Again, pretty much content-free. For all you know some application was
creating savepoints, needlessly:

https://www.postgresql.org/docs/10/static/sql-savepoint.html

and not cleaning up after itself.

The content is here:

"Following the Prime Day outage, Amazon engineers filled out a 25-page
report, which Amazon calls a correction of error. It's a standard
process that Amazon uses to try to understand why a major incident took
place and how to keep it from happening in the future."

Not sure if that is publicly available or not, though my hunch is no.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com