the "/usr/local/pgsql/data" directory size

Поиск
Список
Период
Сортировка
От Al Bean
Тема the "/usr/local/pgsql/data" directory size
Дата
Msg-id F42E1vFfjneUUAqvQNF00002139@hotmail.com
обсуждение исходный текст
Ответы Re: the "/usr/local/pgsql/data" directory size  (Joe Conway <mail@joeconway.com>)
Re: the "/usr/local/pgsql/data" directory size  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
Hi,

I've been evaluating postgres for the past few days and I really like it.

But my targeted system is semi-embedded.  I'm going to have about 32MB of
RAM
and about 256MB of disk space.  Most of the embedded db's that I've
evaluated
just don't make the grade (even some non-embedded ones that I looked at.)
Our
data size will be near 250MB in worst Case and more like 225MB in average
case
situations.

So if I allocate 25MB for user programs like postgres (the OS and other
system
files are actually in a ROM) I'll be able to cover most situations.

Now, after compiling postgres and running initdb I noticed a the data
directory
is a little over 23MB.  I understand that much of this is allocated to
system
tables but is there anyway to (significantly) decrease the overall size
here?
For example the template1 db probably resides in here.  would it be possible
to
create a user db and then delete the template1 db or even simply use the
template1 db?

Thanks guys,
Al

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail


В списке pgsql-general по дате отправления:

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: Size for vacuum_mem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Segmentation fault in 7.3 while vacuuming