Tom Lane wrote: > One place that I've always wanted to look at was suppressing the > creation of a btree metapage until there's some useful data in the > table. We managed to avoid creating a root page until there's data, > but at the time avoiding the metapage seemed too invasive. (Admittedly, > though, if one assumes that your real world case does involve putting > some data in the tables, this wouldn't actually save anything...)
Agreed on the parenthised comment -- it'd be just benchmark optimization. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers