| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org, Gunnlaugur Thor Briem <gunnlaugur(at)gmail(dot)com> |
| Subject: | Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT |
| Date: | 2015-03-06 18:36:01 |
| Message-ID: | 995.1425666961@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicolas Paris | 2015-03-06 20:26:27 | Re: PG 9.3 materialized view VS Views, indexes, shared memory |
| Previous Message | Jeff Janes | 2015-03-06 18:18:31 | Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT |