Received: from ece.rice.edu (ece.rice.edu [128.42.4.34]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1EGhcE11692 for ; Thu, 14 Feb 2002 11:43:38 -0500 (EST) (envelope-from reedstrm@rice.edu) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with ESMTP id EF47968A17; Thu, 14 Feb 2002 10:43:42 -0600 (CST) Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by ece.rice.edu (Postfix) with ESMTP id 5A29B68A0E; Thu, 14 Feb 2002 10:43:41 -0600 (CST) Received: from reedstrm by wallace.ece.rice.edu with local (Exim 3.34 #1 (Debian)) id 16bOyz-0003rd-00; Thu, 14 Feb 2002 10:43:41 -0600 Date: Thu, 14 Feb 2002 10:43:41 -0600 From: "Ross J. Reedstrom" To: Torbj?rn Andersson Cc: Frank Bax , pgsql-sql@postgresql.org Subject: Re: How long does it take? Message-ID: <20020214164341.GG14459@rice.edu> Mail-Followup-To: "Ross J. Reedstrom" , Torbj?rn Andersson , Frank Bax , pgsql-sql@postgresql.org References: <3.0.6.32.20020213211245.007d65b0@pop6.sympatico.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.27i X-Virus-Scanned: by AMaViS snapshot-20010714 X-Archive-Number: 200202/155 X-Sequence-Number: 6582 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