Re: moving from MySQL to pgsql

On 2012-10-13, Merlin Moncure <mmoncure@gmail.com> wrote:
> 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.
>

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