| From: | James David Smith <james(dot)david(dot)smith(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Running two queries concurrently? |
| Date: | 2013-09-10 14:54:58 |
| Message-ID: | CAMu32AA72J=c7WCmS_bg0VnFrwd95gfBoUJhB+jVS56iSPG_bQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi there,
The more and more that I use PostgreSQL the more technical my queries
are seeming to become, so here is the latest question/scenario I could
do with some advice on please. Take the following hypothetical
situation:
QueryOne: I select 10000 rows from TABLE A using CRITERIA Y, and
insert the result into TABLE B. This query takes 20 minutes to run.
QueryTwo: Two minutes after QueryOne has begun, I select 5000 rows
from TABLE A using CRITERIA X, and insert the result into TABLE B.
This query takes 10 minutes to run.
So my question really is, is this possible? I would have thought that
perhaps QueryOne puts a lock on TABLE A and TABLE B while it is
selecting data from one and inserting into the other, but maybe not?
At the moment I have to do QueryOne and then QueryTwo quite a few
times, but have been doing them one after another. Maybe I can
actually run them at the same time?
Best wishes
James
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2013-09-10 16:00:34 | Re: Running two queries concurrently? |
| Previous Message | e-letter | 2013-09-10 09:56:27 | Re: apply sum function after group by extract month date |