Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@xxxxxxxxxx> writes: > On Fri, 2010-09-03 at 09:41 -0400, Tom Lane wrote: >>> This is 8.4.4 btw... >> >> OK, so the bug is fixed, but you still have fillfactor = 0 on the >> affected table. > I'm confused. I'm still seeing a bug in here: I cannot restore a dump > effectively... Running CLUSTER or VACUUM FULL does not make any sense to > me in here. Oh, wait. What you need is this patch: 2010-06-06 23:01 itagaki * doc/src/sgml/ref/create_table.sgml, src/backend/access/common/reloptions.c (REL8_4_STABLE): Ensure default-only storage parameters for TOAST relations to be initialized with proper values. Affected parameters are fillfactor, analyze_threshold, and analyze_scale_factor. Especially uninitialized fillfactor caused inefficient page usage because we built a StdRdOptions struct in which fillfactor is zero if any reloption is set for the toast table. In addition, we disallow toast.autovacuum_analyze_threshold and toast.autovacuum_analyze_scale_factor because we didn't actually support them; they are always ignored. Report by Rumko on pgsql-bugs on 12 May 2010. Analysis by Tom Lane and Alvaro Herrera. Patch by me. Backpatch to 8.4. which I now realize went in *post* 8.4.4. We're really overdue for a new set of back-branch releases ... 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
