On Sat, Oct 13, 2012 at 3:22 AM, Jasen Betts <jasen@xnet.co.nz> wrote:
> On 2012-10-11, Vineet Deodhar <vineet.deodhar@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