On 2012-10-13, Merlin Moncure <mmoncure@xxxxxxxxx> wrote: > 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. > So, $5/gigabyte, and shorter life than disk, I can see how that could start to hurt if you need to deploy a thousand. -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
