| From: | preetika tyagi <preetikatyagi(at)gmail(dot)com> |
|---|---|
| To: | pgsql-students(at)postgresql(dot)org |
| Subject: | query execution time |
| Date: | 2011-03-21 04:59:33 |
| Message-ID: | AANLkTi=FhaO5mX_YdqqsF1Yh0YNEHW8H1f0AUdpE0Fmo@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-students |
Hi,
I am wondering if someone can help me understand the following query
execution behavior:
I have two similar tables and table2 consists of 5000000 records.
Query: INSERT INTO table1 SELECT * FROM table2.
Execution Time: A ms.
Query: INSERT INTO table1 SELECT * FROM table2.
Execution Time: B ms.
Sometimes B >> A (B is very larger than A). Both queries are same and run
twice. What could be the reason that the same query is taking very long
sometime?
Thanks a lot!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Selena Deckelmann | 2011-03-21 05:09:17 | Re: query execution time |
| Previous Message | Andy Colson | 2011-03-21 03:26:16 | Re: Database Design for Components and Interconnections |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Selena Deckelmann | 2011-03-21 05:09:17 | Re: query execution time |
| Previous Message | preetika tyagi | 2011-03-15 19:49:46 | Slow INSERT as compared to UPDATE |