From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Alexander Voytsekhovskyy <young(dot)inbox(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Query plan: SELECT vs INSERT from same select |
Date: | 2019-07-23 21:18:10 |
Message-ID: | 29965.1563916690@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alexander Voytsekhovskyy <young(dot)inbox(at)gmail(dot)com> writes:
> You can see explain analyze verbose here:
> https://explain.depesz.com/s/AEWj
> The problem is, when i wrap it to
> A)
> INSERT INTO norepl_1542_result (axis_x1, axis_y1, v_1)
> SELECT .... SAME QUERY
> OR even
> B)
> WITH rows AS (
> ... SAME SELECT QUERY ...
> )
> INSERT INTO norepl_1542_result (axis_x1, axis_y1, v_1)
> SELECT * FROM rows
> The query time dramatically drops to 500+ seconds.
> You can see explain analyze verbose here
> https://explain.depesz.com/s/AEWj
That's the same link.
> As you can see, 100% of time goes to same SELECT query, there is no issues
> with INSERT-part
We can't see any such thing from what you posted.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-07-23 22:01:25 | Re: Query plan: SELECT vs INSERT from same select |
Previous Message | Igor Korot | 2019-07-23 20:33:15 | Re: Query plan: SELECT vs INSERT from same select |