Re: Need advice about triggers - Mailing list pgsql-performance

From Hannu Krosing
Subject Re: Need advice about triggers
Date
Msg-id 1063206334.3356.12.camel@fuji.krosing.net
Whole thread Raw
In response to Re: Need advice about triggers  ("Mindaugas Riauba" <mind@bi.lt>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Hardware recommendations to scale to silly load
Next
From: Josh Berkus
Date:
Subject: Re: Reading data in bulk - help?