Re: Minimum database size - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Minimum database size
Date
Msg-id Pine.LNX.4.30.0202261446120.685-100000@peter.localdomain
Whole thread Raw
In response to Minimum database size  ("Rohit Dewan" <rdewan@cisco.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "Eugene Chiu"
Date:
Subject: configure --with-pam
Next
From: Tom Lane
Date:
Subject: Re: Help pg_restore