Re: Update command too slow

Hi,

There aren't any triggers but there are 75262 update
statements. The problem is that we have a datatype
called as "Collection" and we are fetching the data
rows into it, modifying the data and call
Collection.save(). This save method generates one
update satement per record present in it.

Thanks,
Venkatesh

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Venkatesh Babu <venkatbabukr(at)yahoo(dot)com> writes:
> > 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
>
> Any triggers or foreign keys on that table? Also,
> what PG version is
> this? Are you doing this in a single UPDATE
> command, or 75262 separate
> commands?
>
> regards, tom lane
>

__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250