Re: Update command too slow - Mailing list pgsql-general

From guegue
Subject Re: Update command too slow
Date
Msg-id e1d1c6910502080027314b9f32@mail.gmail.com
Whole thread Raw
In response to Update command too slow  (Venkatesh Babu <venkatbabukr@yahoo.com>)
List 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@yahoo.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
>

pgsql-general by date:

Previous
From: javier wilson
Date:
Subject: create aggregates to concatenate
Next
From: guegue
Date:
Subject: Re: Update command too slow