Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@xxxxxxxxxx> writes: > On Thu, 2010-09-02 at 13:22 -0400, Tom Lane wrote: >> Devrim, have you identified yet which tables have the bloat? Are they >> the ones with tweaked autovacuum parameters? > That's it. > On prod server, that table consumes 50 GB disk space, and on the backup > machine, it uses 148 GB. I applied custom autovac settings only to that > table. > This is 8.4.4 btw... OK, so the bug is fixed, but you still have fillfactor = 0 on the affected table. > So, what should I do now? Explicitly reset the table's fillfactor to default (100), then you'll need to CLUSTER or VACUUM FULL or something. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
