Re: (auto-)analyze causing bloat/load

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: (auto-)analyze causing bloat/load
Date: 2014-10-18 18:30:53
Message-ID: 24076.1413657053@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andres Freund <andres(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2014-10-18 18:33:57 Re: (auto-)analyze causing bloat/load
Previous Message BRUSSER Michael 2014-10-18 18:21:22 initdb failure on RH 5.10