embed postgresql installation : tuning size/performance [off-topic]

From: Pedro Salazar <pedro-b-salazar(at)ptinovacao(dot)pt>
To: pgsql-admin(at)postgresql(dot)org
Subject: embed postgresql installation : tuning size/performance [off-topic]
Date: 2003-07-01 18:38:52
Message-ID: 1057084731.4468.39.camel@vitoria.intra.cet.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings,

I'm working on small linux distribution (about 80Mb) to put it in on a
USB flash device (128Mb probably).

I'm interested to deploy a postgresql database but I would like to
reduce its size to the maximum possible - space is vital.

1) I have one installation in my workstation (7.3.2) with java support
and the size in /usr/local/pgqsl (bin,lib,include) is about 9.2Mb.
The installation of postgresql binaries+lib files are only inside
/usr/local/pgsql directory (--prefix)? So, can I assume I have to add
only this space to my linux distribution? Or there are other files?

2) Can I strip out the debug and symbols information from the libraries
and binaries?

3) Is possible to limit the size of my database in a similar way we do
in oracle datafiles, or should we put it in a separate partition to
avoid the growing of a database files?

4) The read/write access to the USB device is weak point of my platform
(USB1.1 ~1Mb/s and USB2.0 ~4.7Mb/s). I'm thinking in ext2/ext3/reiserfs
to the filesystem. Do you have any advice to the tuning of my database?

thanks,
Pedro Salazar.
--
PS
pedro-b-salazar(at)ptinovacao(dot)pt
PGP:0E129E31D803BC61

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-07-01 19:29:47 Re: zero (o) return code on failure of pg_dump
Previous Message Daniel Seichter 2003-07-01 16:08:56 Re: postgreSQL users = LDAP users?