Re: Confused by 'timing' results

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: A J <s5aly(at)yahoo(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Confused by 'timing' results
Date: 2010-09-02 17:56:56
Message-ID: AANLkTinyeLbvHSOaGSYxPAMQG9nt5nzDpzXM_6+Vg_vT@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Sep 2, 2010 at 11:34 AM, A J <s5aly(at)yahoo(dot)com> wrote:
> Kevin
> The problem I am trying to solve is:
> measure accurately both the database server time + network time when several
> clients connect to the database from different geographic location.
> All the clients hit the database simultaneously with a long script each of
> insert/update/select queries.

Then that's what you should test. create long scripts, run them from
different locales, and measure the overall time differences, if any,
of the same file from different locales.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-09-02 18:06:43 Re: Confused by 'timing' results
Previous Message A J 2010-09-02 17:34:30 Re: Confused by 'timing' results