Re: moving from MySQL to pgsql - Mailing list pgsql-general

From Jasen Betts
Subject Re: moving from MySQL to pgsql
Date
Msg-id k5b8bg$82h$1@reversiblemaps.ath.cx
Whole thread Raw
In response to moving from MySQL to pgsql  (Vineet Deodhar <vineet.deodhar@gmail.com>)
Responses Re: moving from MySQL to pgsql  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
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?


--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: moving from MySQL to pgsql
Next
From: Jasen Betts
Date:
Subject: Re: non-integer constant in ORDER BY: why exactly, and documentation?