Re: Update command too slow

From: guegue <guegue(at)gmail(dot)com>
To: Venkatesh Babu <venkatbabukr(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Update command too slow
Date: 2005-02-08 08:27:27
Message-ID: e1d1c6910502080027314b9f32@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How are you updating this tables? Do you use UPDATE .... WHERE ....

On Fri, 4 Feb 2005 05:57:32 -0800 (PST), Venkatesh Babu
<venkatbabukr(at)yahoo(dot)com> wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message guegue 2005-02-08 08:27:50 Re: Update command too slow
Previous Message javier wilson 2005-02-08 08:19:41 create aggregates to concatenate