On Fri, Apr 16, 2010 at 11:59:38AM +0200, Szymon Guz wrote: > File pages are not fully filled from the start as that could result in bad > performance of queries later.
The manual page you linked to says something else: "The fillfactor for a table is a percentage between 10 and 100. 100 (complete packing) is the default." However, the index has a default fill factor of 90, so I guess I can tweak that to 100 to shave off another few percent. (there will be no updates nor extra inserts on these tables) Thanks for the tip! I hope there are more ways to tweak it, though because this doesn't save that much. Regards, Peter -- http://sjamaan.ath.cx -- "The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music." -- Donald Knuth -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
