pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ross J. Reedstrom <reedstrm@rice.edu>
To: Torbj?rn Andersson <tobbe@embryo.se>
Cc: Frank Bax <fbax@sympatico.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: How long does it take?
Date: Thu, 14 Feb 2002 10:43:41 -0600
Message-ID: <20020214164341.GG14459@rice.edu> (raw)
In-Reply-To: <B8914D6E.1785%tobbe@embryo.se>
References: <3.0.6.32.20020213211245.007d65b0@pop6.sympatico.ca>
	<B8914D6E.1785%tobbe@embryo.se>

Do realize that you're timing the psql frontend with this, not the 
postgresql backend: the only number from that with any meaning is 
the 'real' wallclock time, and that will be affected by other loads
on either system, or the network between them.

Ross


On Thu, Feb 14, 2002 at 11:18:06AM +0100, Torbj?rn Andersson wrote:
> Den 02-02-14 03.12 skrev Frank Bax fr?n  fbax@sympatico.ca f?ljande:
> 
> > time psql -c "select now()"
> >         now
> > ------------------------
> > 2002-02-13 21:21:17-05
> > (1 row)
> > 
> >   0.09s real     0.05s user     0.01s system
> 
> Thanx!
> 
> Exactly what I needed.
> 
> Regards
> 
> Torbj?rn Andersson
> ---------------------------------------------------
> Embryo Communication      phone: +46 (0) 31-774 39 11(00)
> Kungsgatan 7a             fax: +46 (0)31 774 07 80
> S-411 19 G?teborg         mobile: 0708-30 70 04
> Sweden                    home: http://www.embryo.se/
>         mail: torbjorn.andersson@embryo.se
> ---------------------------------------------------
> "Att idag t?nka annorlunda ?n ig?r skiljer den vise fr?n den envise." ? John
> Steinbeck
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster



view thread (6+ messages)

Message-ID: <20020214164341.GG14459@rice.edu>
Permalink:  ../20020214164341.GG14459@rice.edu/
Also on:    postgresql.org/message-id/20020214164341.GG14459@rice.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: reedstrm@rice.edu, tobbe@embryo.se, fbax@sympatico.ca
  Subject: Re: How long does it take?
  In-Reply-To: <20020214164341.GG14459@rice.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox