Re: UPDATE

From: Dennis Brakhane <brakhane(at)googlemail(dot)com>
To: c k <shreeseva(dot)learning(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: UPDATE
Date: 2009-02-19 22:01:22
Message-ID: 226a19190902191401i6f7f4c4cn6c95eaa44ffdfd14@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 19, 2009 at 7:08 PM, c k <shreeseva(dot)learning(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-02-19 23:43:19 where to divide application and database
Previous Message Frank Featherlight 2009-02-19 21:44:19 Re: Service not starting during install