Re: updating all records of a table - Mailing list pgsql-general

From Willy-Bas Loos
Subject Re: updating all records of a table
Date
Msg-id AANLkTikOLaPZi3ZOc_BtbyrX7Tdr5ssVmviZvTOLqago@mail.gmail.com
Whole thread Raw
In response to Re: updating all records of a table  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
you might consider lowering the fillfactor a bit. It will consume more space, but it will make updates and inserts faster.

fillfactor (integer)

The fillfactor for a table is a percentage between 10 and 100. 100 (complete packing) is the default. When a smaller fillfactor is specified, INSERT operations pack table pages only to the indicated percentage; the remaining space on each page is reserved for updating rows on that page. This gives UPDATE a chance to place the updated copy of a row on the same page as the original, which is more efficient than placing it on a different page. For a table whose entries are never updated, complete packing is the best choice, but in heavily updated tables smaller fillfactors are appropriate. This parameter cannot be set for TOAST tables.--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw

pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: Re: Why count(*) doest use index?
Next
From: matty jones
Date:
Subject: Web Hosting