| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Time of query result delivery |
| Date: | 2014-01-21 18:55:49 |
| Message-ID: | 52DEC2B5.9090700@agliodbs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 01/20/2014 05:55 AM, ARCEnergo wrote:
> Time: 1.211 ms
> | Physical | Virtaul
> --------------------------------------------------
> from PC "Total runtime" | 0.05x ms | 0.05x ms
> --------------------------------------------------
> from PC timing | 0.7 ms | 1.211 ms <-- strange
> --------------------------------------------------
> from server "Total runtime"| 0.05x ms | 0.05x ms
> --------------------------------------------------
> from server timing | 0.55 ms | 0.6 ms
I'm really not clear on what you're trying to measure here. If you're
doing "time" from your PC, then network transmission time completely
dominates your reponse time ... and that can be affected by all kinds of
random variables.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2014-01-22 20:01:39 | Re: Time of query result delivery |
| Previous Message | Mark Kirkwood | 2014-01-21 18:53:20 | Re: Increasing query time after updates |