On Sat, Oct 13, 2012 at 3:22 AM, Jasen Betts <jasen@xxxxxxxxxx> wrote: > On 2012-10-11, Vineet Deodhar <vineet.deodhar@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
