| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | preetika tyagi <preetikatyagi(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: query execution time |
| Date: | 2011-03-21 16:06:34 |
| Message-ID: | 376244CD-113E-4A82-A346-54D819B96947@elevated-dev.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-students |
On Mar 21, 2011, at 9:55 AM, preetika tyagi wrote:
> For example, if A is 15 minutes, then B is 1.5 hrs.
Well, considering that random disk access is on the order of 10,000 times slower than RAM...
But you can answer the question yourself by comparing the query run against cold caches (after a reboot, or various command-line tricks to purge cache) vs against warm caches (twice back-to-back).
--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vick Khera | 2011-03-21 16:30:44 | Re: Fw: slony- No index found |
| Previous Message | preetika tyagi | 2011-03-21 15:55:23 | Re: query execution time |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Selena Deckelmann | 2011-03-21 16:57:05 | Re: foreign data wrappers |
| Previous Message | preetika tyagi | 2011-03-21 15:55:23 | Re: query execution time |