Craig Ringer wrote:
Heikki Linnakangas wrote:

Did you dump and reload the table after setting the fill factor? It only affects newly inserted data.

VACUUM FULL or CLUSTER should do the job too, right? After all, they recreate the table so they must take the fillfactor into account.

CLUSTER, yes. VACUUM FULL won't move tuples around just to make room for the fillfactor.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to