Re: Time of query result delivery - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Time of query result delivery
Date
Msg-id 52E023A3.10601@agliodbs.com
Whole thread Raw
In response to Time of query result delivery  (ARCEnergo <it@kipspb.ru>)
List pgsql-performance
On 01/22/2014 12:19 AM, ARCEnergo wrote:
> Hello, Josh.
>
> Thank you for your response.
> I measured that "times" many many times
> and always I got larger repnose time from VM-server.
> And always server times (EXPLAIN ANALYZE) were very similar.
> And several tests with iperf always shown similar results for both Ph and
> VM servers.
> So, we have practically same server time and same network speed,
>  but different results for timing in psql.
> I wolud like to know what is the reason?

The difference would most likely be something in your VM environment.
Beyond that, I can't speculate.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Time of query result delivery
Next
From: Robert DiFalco
Date:
Subject: Removing nulls with 6NF