Re: Minimum database size

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Minimum database size
Дата
Msg-id Pine.LNX.4.30.0202261446120.685-100000@peter.localdomain
обсуждение исходный текст
Ответ на Minimum database size  ("Rohit Dewan" <rdewan@cisco.com>)
Список 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 по дате отправления:

Предыдущее
От: "Eugene Chiu"
Дата:
Сообщение: configure --with-pam
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Help pg_restore