Re: Oracle vs PG

A Twitter thread from someone who talked with the reporter (also read Werner's statement referenced in the first tweet): https://twitter.com/andy_pavlo/status/1055154039606910976 Mark

Re: Oracle vs PG

Michael Paquier writes: > On Wed, Oct 24, 2018 at 07:31:57AM +0200, Laurenz Albe wrote: > >> I have seen people use savepoints in PostgreSQL to emulate Oracle's >> "statement rollback" behavior: If a statement fails, only the statement >> is undone, but the transaction continues. >> >> If you in

Re: Oracle vs PG

On Wed, Oct 24, 2018 at 07:31:57AM +0200, Laurenz Albe wrote: > I have seen people use savepoints in PostgreSQL to emulate Oracle's > "statement rollback" behavior: If a statement fails, only the statement > is undone, but the transaction continues. > > If you insert a savepoint before *every* sta

Re: Oracle vs PG

Ravi Krishna wrote: > I have hardly used savepoints in any application, but if I understand it > correctly, isn't it something which is typically used > in a persistent connection. I wonder how it is applicable in a web based > stateless application like Amazon.com, unless > even web based appli

Re: Oracle vs PG

Ravi Krishna writes: >> 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 > > I have hardly used savepoints in any application, but if I understand it > correctly, isn't

Re: Oracle vs PG

> > Amazon's web store may be a (mostly) stateless application, that doesn't mean > their back end applications are. > Oh yes. There is nothing in that article which suggests that the root cause of the outage was in the web based apps. As you indicated, their back end may be the source of the

Re: Oracle vs PG

On Tue, Oct 23, 2018 at 6:36 PM Ravi Krishna wrote: > > I have hardly used savepoints in any application, but if I understand it > correctly, isn't it something which is typically used > in a persistent connection. I wonder how it is applicable in a web based > stateless application like Amazon.

Re: Oracle vs PG

>I have hardly used savepoints in any application, but if I understand >it correctly, isn't it something which is typically used >in a persistent connection. I wonder how it is applicable in a web >based stateless application like Amazon.com, unless >even web based application have database lev

Re: Oracle vs PG

> 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 I have hardly used savepoints in any application, but if I understand it correctly, isn't it something which is typically

Re: Oracle vs PG

e 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 afte

Re: Oracle vs PG

> > Is it so hard to accept commercial databases have advantages? > I find that not one bit surprising. > > I've used PG since 90's and it's no secret the "big guys" beat PG on certain > workloads. > In my previous workplace where they tested EDB to replace PG, they found all PL/SQL based co

Sv: Re: Sv: Re: Oracle vs PG

På tirsdag 23. oktober 2018 kl. 23:36:29, skrev Adrian Klaver < adrian.kla...@aklaver.com >: On 10/23/18 2:34 PM, Andreas Joseph Krogh wrote: > På tirsdag 23. oktober 2018 kl. 22:45:36, skrev Adrian Klaver > mailto:adrian.kla...@aklaver.com>>: > >     On 10/23/

Re: Sv: Re: Oracle vs PG

On 10/23/18 2:34 PM, Andreas Joseph Krogh wrote: På tirsdag 23. oktober 2018 kl. 22:45:36, skrev Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 10/23/18 12:58 PM, Ravi Krishna wrote: > Well it is Aurora. > > https://www.cnbc.com/2018/10/23/amazon-move-off-oracle-ca

Sv: Re: Oracle vs PG

På tirsdag 23. oktober 2018 kl. 22:45:36, skrev Adrian Klaver < adrian.kla...@aklaver.com >: On 10/23/18 12:58 PM, Ravi Krishna wrote: > Well it is Aurora. > > https://www.cnbc.com/2018/10/23/amazon-move-off-oracle-caused-prime-day-outage-in-warehouse.html >

Re: Oracle vs PG

Adrian Klaver writes: > On 10/23/18 12:58 PM, Ravi Krishna wrote: > >> Well it is Aurora. >> >> https://www.cnbc.com/2018/10/23/amazon-move-off-oracle-caused-prime-day-outage-in-warehouse.html >> > > Since the article was almost content-free I not would use it on either > side of the argument. Th

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:

Re: Oracle vs PG

Em ter, 23 de out de 2018 às 17:48, Ravi Krishna escreveu: > > 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 h

Re: Oracle vs PG

Em ter, 23 de out de 2018 às 17:46, Adrian Klaver escreveu: > > On 10/23/18 12:58 PM, Ravi Krishna wrote: > > Well it is Aurora. > > > > https://www.cnbc.com/2018/10/23/amazon-move-off-oracle-caused-prime-day-outage-in-warehouse.html > > > > Since the article was almost content-free I not would us

Re: Oracle vs PG

> > 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

Re: Oracle vs PG

On 10/23/18 12:58 PM, Ravi Krishna wrote: Well it is Aurora. https://www.cnbc.com/2018/10/23/amazon-move-off-oracle-caused-prime-day-outage-in-warehouse.html 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 Amazo