this is my "schema" for the table with the "issue" !
# \d url_importance
Table "public.url_importance"
Column | Type | Modifiers
-----------+------------------+-------------------------------------
url_id | bigint | default nextval('url_id_seq'::text)
links_in | integer | default 0
links_out | integer | default 0
rank | double precision | default 0
Indexes:
"ak_url_id_key_url_impo" unique, btree (url_id)
Foreign-key constraints:
"fk_url_impo_reference_url" FOREIGN KEY (url_id) REFERENCES url(url_id) ON UPDATE CASCADE ON DELETE CASCADE
based on this table i calculate the "rank" for each page and the
reupdate the table.
on update it takes QUITE a lot time to make the update.
basically i am updating just a number which sould not be that resource
consuming !
is upgrading to 8.X a "solution" in this case ?
p.s.: i am not updating anything except the rank column !
Tuesday, June 28, 2005, 4:01:02 PM, Bruno Wolff III wrote:
> Do you have indexes on the foreign key fields in the referencing tables?
> These are created by default and if you are updating the referenced tupples
> a sequential search will be needed if there isn't an index.
> Also of note is that there is recent a change to only do this if the referenced
> fields in the record are changed, but I think this is new for 8.1. That
> will make things go a lot faster if you aren't updating the referenced
> fields in your main table.
--
Catalin Constantin
Bounce Software
http://www.bounce-software.com
http://www.cabanova.ro