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
Re: the "/usr/local/pgsql/data" directory size |
Список | 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 по дате отправления: