On Sat, Oct 13, 2012 at 3:22 AM, Jasen Betts <ja...@xnet.co.nz> wrote: > On 2012-10-11, Vineet Deodhar <vineet.deod...@gmail.com> wrote: > >> To give an example, I have tables for storing master records (year master, >> security master, etc.) for which pkid TINYINT is just sufficient. >> These pkid's are used as fk constraints in tables for storing business >> transactions. >> The no. of rows in business transactions tables is in millions. >> Here, I NEED to worry about the storage space occupied by the pkid fields. > > with disk at about 50c/Gigabyte why is it you need to worry?
see upthread: OP is running off a USB stick. If he's running MyISAM, the postgres database is going to be larger and there is going to be a lot more writing than he's used to. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
