Joe Conway <mail(at)joeconway(dot)com> writes:
> Al Bean wrote:
>> Now, after compiling postgres and running initdb I noticed a the data
>> directory is a little over 23MB.
> Other things I can think of:
> 1. Reduce NAMEDATALEN
> 2. Reduce INDEX_MAX_KEYS
Neither of those are likely to change the disk footprint a lot, since
the system catalogs aren't a significant proportion of any real-world
database, I should think.
The majority of the initial footprint is the first xlog segment file
(16MB). For a low-traffic installation you could consider reducing
the xlog segment size. This'd have less impact on interoperability
than the other changes, too, since it's not visible to clients.
regards, tom lane