Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT - Mailing list pgsql-performance

Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> On 6.3.2015 01:44, Tom Lane wrote:
>> I'm wondering about the issue addressed by commit fccebe421 ("Use
>> SnapshotDirty rather than an active snapshot to probe index
>> endpoints").

> How would fccebe421 explain the large amount of random writes (~4MB/s
> for more than an hour), reported in the initial post? And why would that
> only affect the EXPLAIN and not the bare query?

Hard to say.  There's probably additional factors involved, and this
may ultimately turn out to be unrelated.  But it seemed like it might
be an issue, particularly since the plan had a mergejoin with lots of
clauses ...

            regards, tom lane