Should've mentioned - running 3.9. Also - please do not recommend MVs: I tried, they're broken, we punted.
On Wed, Dec 7, 2016 at 10:06 AM, Voytek Jarnot <voytek.jar...@gmail.com> wrote: > The low default value for batch_size_warn_threshold_in_kb is making me > wonder if I'm perhaps approaching the problem of atomicity in a non-ideal > fashion. > > With one data set duplicated/denormalized into 5 tables to support > queries, we use batches to ensure inserts make it to all or 0 tables. This > works fine, but I've had to bump the warn threshold and fail threshold > substantially (8x higher for the warn threshold). This - in turn - makes > me wonder, with a default setting so low, if I'm not solving this problem > in the canonical/standard way. > > Mostly just looking for confirmation that we're not unintentionally doing > something weird... >