This article is half-done without your Comment! *** Please share your thoughts via Comment ***
This is one of the important post related to change or set the Fillfactor value for the existing table of the PostgreSQL.
One of our tables is very busy with a large number of updates and access by multiple clients.
I also estimated the row size of that table which is not that much bigger, so I decided to change the Fillfactor of that table.
I have recently published an article about the importance of Fillfactor in PostgreSQL.
|
1 2 |
ALTER TABLE table_name SET ( fillfactor = 50); VACUUM FULL table_name; |
Please Note:
After changing the value of Fillfactor, you should execute VACUUM FULL on that particular table.
After changing the value of Fillfactor, it works only for new tuples.
