Re: moving from MySQL to pgsql

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