| From: | Selena Deckelmann <selena(at)chesnok(dot)com> |
|---|---|
| To: | preetika tyagi <preetikatyagi(at)gmail(dot)com> |
| Cc: | pgsql-students(at)postgresql(dot)org |
| Subject: | Re: query execution time |
| Date: | 2011-03-21 05:09:17 |
| Message-ID: | AANLkTi=bDEO0a==rCX+JBmEKV541C2=53gEPnu_gQxJi@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-students |
Hi!
This mailing list is for GSoC students to discuss their proposals.
Please direct your question to pgsql-general(at)postgresql(dot)org(dot)
-selena
On Sun, Mar 20, 2011 at 9:59 PM, preetika tyagi <preetikatyagi(at)gmail(dot)com> wrote:
> 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 | preetika tyagi | 2011-03-21 05:12:37 | query execution time |
| Previous Message | preetika tyagi | 2011-03-21 04:59:33 | query execution time |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | preetika tyagi | 2011-03-21 05:12:37 | query execution time |
| Previous Message | preetika tyagi | 2011-03-21 04:59:33 | query execution time |