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

From: "Al Bean" <albean84(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: the "/usr/local/pgsql/data" directory size
Date: 2002-12-05 22:02:53
Message-ID: F42E1vFfjneUUAqvQNF00002139@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-12-05 22:51:48 Re: Segmentation fault in 7.3 while vacuuming
Previous Message Robert Treat 2002-12-05 21:57:56 Re: Size for vacuum_mem