Thread: "toast.fillfactor" is documented but not recognized?
Hi, I tried to utilize the advertised feature of 8.4, the separate fillfactor setting for the toast table. o=# create table t2 (id serial primary key, t text) with (fillfactor=75, toast.fillfactor=60); NOTICE: CREATE TABLE will create implicit sequence "t2_id_seq" for serial column "t2.id" ERROR: unrecognized parameter "fillfactor" The same error happens on 8.4.1 and 8.5CVS. The error disappears only if I omit the "toast.fillfactor" setting completely. Best regards, Zoltán Böszörményi -- Bible has answers for everything. Proof: "But let your communication be, Yea, yea; Nay, nay: for whatsoever is more than these cometh of evil." (Matthew 5:37) - basics of digital technology. "May your kingdom come" - superficial description of plate tectonics ---------------------------------- Zoltán Böszörményi Cybertec Schönig & Schönig GmbH http://www.postgresql.at/
Boszormenyi Zoltan wrote: > Hi, > > I tried to utilize the advertised feature of 8.4, the > separate fillfactor setting for the toast table. > > o=# create table t2 (id serial primary key, t text) with (fillfactor=75, > toast.fillfactor=60); > NOTICE: CREATE TABLE will create implicit sequence "t2_id_seq" for > serial column "t2.id" > ERROR: unrecognized parameter "fillfactor" We explicitely disallow setting fillfactor on toast tables. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
On Mon, 2009-10-26 at 19:11 -0300, Alvaro Herrera wrote: > We explicitely disallow setting fillfactor on toast tables. So should that be made more clear in the documentation? http://www.postgresql.org/docs/8.4/static/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS Looking at that page briefly I would assume that it could be set. Regards,Jeff Davis
Jeff Davis <pgsql@j-davis.com> wrote: > http://www.postgresql.org/docs/8.4/static/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS > Looking at that page briefly I would assume that it could be set. Oops, I forgot to fix the description when I disable toast.fillfactor. Please just remove it from documentation. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center
Itagaki Takahiro wrote: > > Jeff Davis <pgsql@j-davis.com> wrote: > > > http://www.postgresql.org/docs/8.4/static/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS > > Looking at that page briefly I would assume that it could be set. > > Oops, I forgot to fix the description when I disable toast.fillfactor. > Please just remove it from documentation. My mistake actually. Fixed. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support