Sample Header Ad - 728x90

What should be the fill-factor for a table where only fixed-width columns will be updated?

2 votes
2 answers
270 views
We have a table where we are planning to update timestamp fields only. In the first import these columns will be nulls then we will update them as the computation finished on these rows. The question is; should we set a fill-factor lower than 100 for this table or PostgreSQL will allocate a fixed size for these columns so lowering the fill-factor makes no sense?
Asked by KARASZI István (123 rep)
Aug 17, 2016, 11:19 AM
Last activity: Aug 17, 2016, 09:20 PM