update slow

From: Josué Maldonado <josue(at)lamundial(dot)hn>
To: pgsql-general(at)postgresql(dot)org
Subject: update slow
Date: 2003-11-11 19:46:48
Message-ID: 3FB13CA8.40005@lamundial.hn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello list,

I have 7.3.4 on RH 8, server hardware is a dual processor Intel Xeon 2.4
Ghz, 2G RAM, 27Gb HD available on postgres partition.

Table cost2est2003 with 99350 recs is described as:
code char(4) -- index
tcos numeric(12,4)
mes char(6) -- index

Table estprod with 355513 recs is described as:
pk_estprod -- index
epr_periodo char(6) -- Index
epr_venta numeric(12,4)
epr_costo numeric(12,4)
pro_code char(4)

This is the update command:
update estprod set epr_costo=(select tcos from cost2est2003 where
code=pro_code and mes=epr_periodo) where epr_periodo >='200301'

The above filters the records to affect only 99157 rows, the update
takes hours and don't get done (I did cancel it), I changed the filter
to "epr_periodo ='200301'" to update only 9756 rows but still has more
than 10 minutes working.

I wonder if there is something I'm doing wrong, any help will be
appreciated. BTW the server is not in production is not doing anything
else. Thanks in advance

--
Josué Maldonado.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-11-11 19:54:27 Re: Proposal for a cascaded master-slave replication system
Previous Message Alvaro Herrera 2003-11-11 19:25:48 Re: PL/Perl returning multiple rows