On Thu, Sep 25, 2014 at 1:30 PM, Andres Freund <and...@2ndquadrant.com> wrote: >> Yes it does cause data loss. The clueful operator has no idea where >> they are so there is no "used rightly" in that case. > > What? There definitely are cases where you don't need to know that to > the T. Just think of the - quite frequently happening - need to promote > a standby to run tests or reporting queries that can't be run on a > standby. > > Sure, you shouldn't use it if you expect a very specific set of the data > being there, but that's not always necessary.
Very well put. +1. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers