X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6C050D1B545 for ; Wed, 10 Sep 2003 16:42:25 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 27763-04 for ; Wed, 10 Sep 2003 13:41:53 -0300 (ADT) Received: from fuji.krosing.net (silmet.estpak.ee [194.126.97.78]) by svr1.postgresql.org (Postfix) with ESMTP id CD4D0D1BB46 for ; Wed, 10 Sep 2003 12:05:48 -0300 (ADT) Received: from fuji.krosing.net (localhost.localdomain [127.0.0.1]) by fuji.krosing.net (8.12.8/8.12.8) with ESMTP id h8AF5ej9003860; Wed, 10 Sep 2003 18:05:40 +0300 Received: (from hannu@localhost) by fuji.krosing.net (8.12.8/8.12.8/Submit) id h8AF5ZrX003858; Wed, 10 Sep 2003 18:05:35 +0300 X-Authentication-Warning: fuji.krosing.net: hannu set sender to hannu@tm.ee using -f Subject: Re: Need advice about triggers From: Hannu Krosing To: Mindaugas Riauba Cc: pgsql-performance@postgresql.org In-Reply-To: <053a01c37785$5f89d4d0$f20214ac@bite.lt> References: <00be01c376cf$91510620$f20214ac@bite.lt> <200309091414.23458.dev@archonet.com> <00dc01c376d6$f9f99c30$f20214ac@bite.lt> <21262.1063118448@sss.pgh.pa.us> <053a01c37785$5f89d4d0$f20214ac@bite.lt> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1063206334.3356.12.camel@fuji.krosing.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Wed, 10 Sep 2003 18:05:35 +0300 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/171 X-Sequence-Number: 3537 Mindaugas Riauba kirjutas K, 10.09.2003 kell 13:21: > > router_db=# explain analyze update ifdata set ifspeed=256000, > ifreason='12121', iflastupdate=CURRENT_TIMESTAMP WHERE clientid='#0003904#'; > QUERY PLAN > ---------------------------------------------------------------------------- > ------------------------------------------------ > Index Scan using ifdata_clientid_key on ifdata (cost=0.00..5.64 rows=1 > width=116) (actual time=0.17..0.36 rows=1 loops=1) > Index Cond: (clientid = '#0003904#'::character varying) > Total runtime: 1.70 msec > (3 rows) could you try the same query on similar table, where clientid is int4 ? is it faster ? does the performance degrade at a slower rate? --------------- Hannu