Alex Rivera | Logout

Changing fillfactor of existing table

Asked 2010-11-12T00:22:35.010
16

Is it possible to change fillfactor of an existing table in PostgreSQL 8.4?

Or do I have to create copy of a table with new fillfactor - which is not the best approach because of foreign key problems?

Edit
Report

1 Answer

33

Yes, that's possible. But you have to VACUUM FULL or CLUSTER this table afterwards to rewrite the table.

ALTER TABLE foo SET ( fillfactor = 50);
VACUUM FULL foo;
answered 2010-11-12T06:13:54.327

Your Answer