Re: (auto-)analyze causing bloat/load

Andres Freund <andres@2ndquadrant.com> writes:
> Interestingly we already set PROC_IN_ANALYZE - but we never actually
> look at it. I wonder what it'd take to ignore analyze in
> GetSnapshotData()/GetOldestXmin()... At first sight it looks quite
> doable to not have a snapshot around (or setup to be ignored) while
> acquire_sample_rows() is running. As that's the expensive bit...

Say what?  How is ANALYZE supposed to know which rows are valid
without a snapshot?
        regards, tom lane