Re: Time of query result delivery

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: ARCEnergo <it(at)kipspb(dot)ru>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Time of query result delivery
Date: 2014-01-22 20:01:39
Message-ID: 52E023A3.10601@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert DiFalco 2014-01-23 16:34:33 Removing nulls with 6NF
Previous Message Josh Berkus 2014-01-21 18:55:49 Re: Time of query result delivery