Update command too slow

From: Venkatesh Babu <venkatbabukr(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Update command too slow
Date: 2005-02-04 13:57:32
Message-ID: 20050204135732.21237.qmail@web50407.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We have a table cm_quotastates which has exactly
4624564 rows and 25 columns and 9 indexes... Out of
these, our code retrieves 75262 rows and modifies just
one column in each row... but updating these to
database is taking some significant time (around 20
minutes)... Tried the following with the update

(a) Tried updating after removing all the 9 indexes
associated with the table
(b) Tried updating the 75K rows in batches
(c) vacuum analyze the table before updation

but none are helping and update still takes the same
amount of time. Is there anything else that can be
done so that update takes lesser time... Also, where
can I find info about how postgres update actually
works?

Thanks,
Venkatesh

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2005-02-04 13:59:26 Re: Postgres using up all my memory
Previous Message Sean Davis 2005-02-04 13:44:42 Re: error-tolerant COPY FROM