Thread: Minimum database size

Rohit Dewan writes:

> What is the size of an empty database?

Have you considered just creating one and looking?

> I heard somewhere that a DB created using CreateDB has a default size
> of about 20MB. Is that true and is that default size configurable.

The size of an empty database is not determined by the amount of useless
data that's put in there.  In other words, no, you can't configure it.

In some installation I have here, the size of an empty database appears to
be about 2MB, but you will find that the database cluster overhead is much
more than that.  You can control some aspect of that by reducing the
number of WAL files, but that will really kill the performance for only a
relatively small space gain.

--
Peter Eisentraut   peter_e@gmx.net