Re: UPDATE - Mailing list pgsql-general

From Dennis Brakhane
Subject Re: UPDATE
Date
Msg-id 226a19190902191401i6f7f4c4cn6c95eaa44ffdfd14@mail.gmail.com
Whole thread Raw
In response to Re: UPDATE  (c k <shreeseva.learning@gmail.com>)
List pgsql-general
On Thu, Feb 19, 2009 at 7:08 PM, c k <shreeseva.learning@gmail.com> wrote:
> As
> all rows are rewritten(newly inserted with changed column value), the
> indices must be updated accordingly and this may take more time?

I'd think so, but I'm no expert.

If you have many and frequent updates, it might be worthwhile to
adjust the fillfactor of the table, so the updated data can be put in
the same page.

pgsql-general by date:

Previous
From: Frank Featherlight
Date:
Subject: Re: Service not starting during install
Next
From: Sam Mason
Date:
Subject: where to divide application and database