Skip site navigation (1) Skip section navigation (2)

Re: query execution time

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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!
>



-- 
http://chesnok.com

In response to

pgsql-students by date

Next:From: preetika tyagiDate: 2011-03-21 05:12:37
Subject: query execution time
Previous:From: preetika tyagiDate: 2011-03-21 04:59:33
Subject: query execution time

pgsql-general by date

Next:From: preetika tyagiDate: 2011-03-21 05:12:37
Subject: query execution time
Previous:From: preetika tyagiDate: 2011-03-21 04:59:33
Subject: query execution time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group