Re: the "/usr/local/pgsql/data" directory size - Mailing list pgsql-general

Joe Conway <mail@joeconway.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