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?
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;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With