Re: existence of a savepoint? - Mailing list pgsql-general

From David G. Johnston
Subject Re: existence of a savepoint?
Date
Msg-id CAKFQuwZpA7n6vw5Ms8CY8Qi6JSq5_C2LjCEWL58v12SKryPxbQ@mail.gmail.com
Whole thread Raw
In response to Re: existence of a savepoint?  (Stuart McGraw <smcg4191@mtneva.com>)
List pgsql-general
On Tuesday, May 29, 2018, Stuart McGraw <smcg4191@mtneva.com> wrote:
 But in my case I don't control the size of the input data 

Not in production but you have an idea of both size and complexity and should be able to generate performance test scenarios, and related monitoring queries (system and service) to obtain some idea.  The specifics are beyond my experience but this is not brand new technology and people have done similar stuff with it before.

And, as an extension to what you said, given such lack of control you are going to want to monitor performance in production anyway even with an assumed bullet-resistant solution.

David J.


pgsql-general by date:

Previous
From: Stuart McGraw
Date:
Subject: Re: existence of a savepoint?
Next
From: Łukasz Jarych
Date:
Subject: Tracking DDL and DML changes in Postgresql and different versions ofdatabase (advance)