On 2016-05-06 19:43:24 -0500, Kevin Grittner wrote: > It's disappointing that I am not getting more consistent numbers, > but NUMA can be hard to manage that way.
FWIW, in my experience, unless you disable autovacuum (or rather auto-analyze), the effects from non-predicable analyze runs with long-running snapshots are worse. I mean the numa effects suck, but in r/w workload effects of analyze are often much worse. That comment reminds me of a question I had: Did you consider the effect of this patch on analyze? It uses a snapshot, and by memory you've not built in a defense against analyze being cancelled. > Will push shortly with the nit-pick fixes you requested. Cool. Greetings, Andres Freund -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers