Re: query execution time - Mailing list pgsql-general

From Scott Ribe
Subject Re: query execution time
Date
Msg-id AABF2DE3-E820-4BCA-BF36-EDD795C919DC@elevated-dev.com
Whole thread Raw
In response to Re: query execution time  (preetika tyagi <preetikatyagi@gmail.com>)
List pgsql-general
On Mar 21, 2011, at 12:03 PM, preetika tyagi wrote:

> I tried running the same query after reboot and back-to-back, it was taking less time in both the cases. It means the
problemis something else. 
>
> Can there be a reason which is more hardware/operating system specific and due to which the behavior is not uniform?

While I do have a couple of ideas, you're probably better served by letting those here with more optimization
experiencehelp you, as their answers will be more complete. 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Passing a table as parameter
Next
From: David Fetter
Date:
Subject: Re: postgres conferences missing videos?